I'm tracking surveys which have 3 fields:
C2 D2 E2
5 6 7
In F2 I'm using the following formula that pulls from a list:
=INDEX((Legend!$B$1:$B$6),MATCH(MAX(C2:E2),C2:E2,0),1)
where the legend is (loosely based on):
B1 Water
B2 Fire
B3 Wind
B4 Combo (water/fire)
B5 Combo (fire/wind)
B6 Combo (water/wind)
The formula works until there's 2 matching numbers. I need the result to show either COMBO then the 2 results from B1-B3, or if there's another way to display the combo that would work too.
Thanks in advance!
C2 D2 E2
5 6 7
In F2 I'm using the following formula that pulls from a list:
=INDEX((Legend!$B$1:$B$6),MATCH(MAX(C2:E2),C2:E2,0),1)
where the legend is (loosely based on):
B1 Water
B2 Fire
B3 Wind
B4 Combo (water/fire)
B5 Combo (fire/wind)
B6 Combo (water/wind)
The formula works until there's 2 matching numbers. I need the result to show either COMBO then the 2 results from B1-B3, or if there's another way to display the combo that would work too.
Thanks in advance!
