How to club Max and index formula

[vinu]

Hello Team,


I have senario where I have 3 column data. Col1 = players name, col2 = county name, col3= scores. Now I need to find out the person of each team who scored maximum.


I used array formula to find out max for each country = MAX(IF(B2:B15="IND",C2:C15))


I used index formula to find out the person = index(col 1, match(above ans,col 3,0))


How do get the end result in one formula/ how do I club this.?


Regards,

Vin

 

[Hui]

Have you tried ?

= index(col 1, match(MAX(IF(B2:B15="IND",C2:C15)),col 3,0))

 

[vinu]

Thanks Hui, Its works fine.