Golf leaderboard duplicates equal scores

[The Shadowman]

Hi. I have created a golf leaderboard which works fine, but if two people have the same total, one disappears leaving the same person in first and second place.

In the score part of the sheet I have a column that calculates the best score using: =LARGE($BI$31:$BI$45,1) this is copied Down for 15 rows.
The next column takes 15 names and places them in top score order using: =INDEX($C$31:$C$45,MATCH(BN31,$BI$31:$BI$45,0)).
This works well until two players have same score, when the last entered will, in this example, show in first and second place and the true second place disappears.

How can I make it that two equal scores show as first and second, and so on?
I will be extremely grateful for any help offered. Thanks
Robert

 

[Fluff]

How about

=INDEX($C$31:$C$45,AGGREGATE(15,6,(ROW($C$31:$C$45)-ROW($C$31)+1)/($BI$31:$BI$45=BN31),COUNTIFS(BN$31:BN31,BN31)))

 

[The Shadowman]

Hi Fluff.

That's marvellous, and thanks for coming back so quickly.

 

[Fluff]

You're welcome & thanks for the feedback.