I am hoping someone can help me solve the problem of how to input the name of a player who is tied for first place. Excel will input only the first name of the high score, yet cannot do so for the other player with the same score.
In A4:A14, I have a list of players. In D4:D14, I have the score for each player.
In D16, I have the top score, using the formula: =LARGE(D4:D13,1).
In cell C16, I have matched the score to the players name using the following formula:
=INDEX(A4:A14,MATCH(MAX(D16),D4:D13,0),1)
In cell C18, I have matched the score to the second highest player's name:
=INDEX(A4:A14,MATCH(MAX(D18),D4:D13,0),1)
The same formula was used for the third place ranking.
The problem I have encountered is in the case where there is a tie for first place. The first instance of the high score will return the corresponding name. However, I cannot return the name for the other player that shares the same high score.
Does this make sense? I appreciate your help!
Bookmarks