I need to list the top three players based on their high score.
However in the event that there are duplicate high scorers I then need to use a secondary value.
The player with the duplicate highest score, and the lowest seconday value will be the higher scorer.
Players names are listed in A5:A24
Players scores are in Y5:Y24
Players secondary score is in Z5:Z24
Top 3 scores displayed in Y1:Y3
=IF(ROWS($Y1:Y$1)<=3,LARGE($Y$5:$Y$24,ROWS($Y1:Y$1)),"")
Top 3 names of scorers displayed in AA1:AA3
{=IF(N($Y1),INDEX($A$6:$A$25,SMALL(IF($Y$6:$Y$25=$Y1,ROW($Y$6:$Y$25)-ROW($Y$6)+1),COUNTIF($Y$1:Y1,Y1))),"")}
Tip.xlsm
Bookmarks