Return Name of Highest Scorer in Excel

This Microsoft Excel video shows how to return the name of the highest scorer from a list of people using the match and Index function.

It is possible to reference an array to return the name of a specific person based on a condition of their score in Excel.

[janoschburchert]

Love you much, I tried it for hours and nobody could help me, only you. Youre the best ❤

[owais-liaqat]

Really helpful. I have been just looking for it for half hour. More power to you.

[vitoriak]

The BEST video about this I've found! Thank you so much!! ♥

[andrewroberts]

bro I have been looking everywhere for this thank you

[cikgunadianordin]

Thanks a lot. I need to figure out the second highest and the third highest

[MrDuckphart]

what happens if another person scored 20 points? I assume it will return the name of the person who appears in that first first. What if I want it to return both of those names?

[egmezut]

Im following this tutorial but I have question. what if tie scores? how to formulate that will appear two numbers? Im using this for our pageant. Thanks for reply

[georgeg]

Hello! By any chance anyone knows how to return both highest score players scores in case of two have the same?

[nonakatried]

How about returning the name of the highest score with only two players with separate cells? I wanna know how

[royetcasue]

What if there are two highest numbers?

[YodaCrafters]

Doesn't work, i tried this =INDEX(D5:D8(MATCH(MAX(F5:F8), F5:F8, 0), 1)

[prahalladjena]

return names of 1st position highest scorer in a database