nabilahms99
New Member
- Joined
- Apr 23, 2018
- Messages
- 3
[FONT=q_serif]Here is the table to help you understand the problem.
[/FONT]
<tbody>
</tbody>[FONT=q_serif]
What formula should I use to get the result like those in “Competitor” column?[/FONT]
[/FONT]
r1 | 8B | GA | ID | IL | IN | IW | JT | QG |
ABU-KOE | 14 | |||||||
AEG-KNO | 7 | |||||||
AMQ-BXB | 1 | |||||||
AMQ-CGK | 14 | 35 | 14 | 7 | ||||
Routes | Competitor | |||||||
ABU-KOE | IW | |||||||
AMQ-CGK | GA, ID, JT, QG |
<tbody>
</tbody>
What formula should I use to get the result like those in “Competitor” column?[/FONT]