Index Tie issue in a Leaderboard

I've put together a leaderboard for a sporting event. I've found many good tips here, but I'm hung up on ties, as the way they display doesn't work. Frankly, this is over my head.

My formula to Index/rank the athletes from highest to lowest is:

=INDEX(F$4:F$25,MATCH(LARGE($F$4:$F$25,X4),$F$4:$F$25,0))

I do not need to break any ties. I only need thee results sorted as such:

A=Rank B=Name C=Score

1 Athlete 1 50
2 Athlete 2 45
2 Athlete 3 45
4 Athlete 4 40
5 Athlete 5 35

Any suggestions would by greatly appreciated. I really have to avoid sorting them manually.

A file would help.

We have no idea what's where, when or why or who's the winner... grand no slammer ya got going here

For example, your LARGE portion of the formula references X4 for the nth largest value. How do you think we are to know what's in X4??? ...or what's in F4:F25???

[QUOTE=jhren;3330770]A file would help.

Apologies for not attaching a file, and thank you for the quick reply. I've attached it here.

The basic premise of the event is:

1. Athletes get 3 runs in their event.
2. Only their highest score counts toward their final rank.
3. The first grid in the sheet collects the judges' scores.
4. The leaderboard automatically updates every time new judge scores are entered.

When there are ties for the Highest Score, the problem arises.

Leadeboard example.xlsx

Thank you all so much! I now have two ways to make this work. I can't even explain how much frustration you just eliminated.

Originally Posted by icestationzbra

see if this is what you meant.

i fudged a couple of numbers in column N (highlighted in red) in order to test out the approach.

Thanks so much for your help. I needed to expand the number of athletes in the event, and I thought I could simply copy the formulas, but I've hit a brick wall. I'm lost as to what happens after the copy-and-paste. I must be overlooking something, but I'm lost. Any idea? new file attached.