Top scores w/ corresponding player, also with a tie

[madman1734]

I have gotten help here before for the ranking. I did a test run and seen I had some ties in scores, but the ranking would only show the first high score and list it twice.
I have attached a sample of what I have.

Any help is greatly appreciated.

mmBowling Tournament.xlsx

[Tony Valko]

Look like you want a top 3 list?

Depending on ties, there could be more than 3 items that make up the top 3 list.

Try this array formula** entered in A18 and copied down to A20:

=INDEX(A$3:A$13,SMALL(IF(E$3:E$13=E18,ROW(E$3:E$13)),COUNTIF(E$18:E18,E18))-ROW(E$3)+1)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[madman1734]

Yes, that worked great. I tried that myself, but as I am not used to formulas all that much, I did not know about array.

Big thanks.

[Tony Valko]

You're welcome. Thanks for the feedback!