Good day,
In the attached file on the 'Game Record' scoresheet, I have to list the top 3 players individual high score for the game.
Notice that in cell L27-L29, three players got the same score of 141. To get the players name, I used the formula:
=INDEX('Player Score'!C6:C113,MATCH(L27,('Player Score'!B6:B113='Player Score'!D119)*'Player Score'!DY6:DY113,0))
This formula is fine if there were no players having the same score, now as in the example attached, this formula will get the
value 'Tess' for K27, K28 and K29.
How do I get the name of the next player with the same score?
Thanks.
Bookmarks