Ranking top scores w/ corresponding players.

[madman1734]

Need a little help here.

Attached is a Bowling Tournament spreadsheet whereas awards are handed out for top scores.

I need to list the top 3 scores w/ the corresponding player for each game and series.

B16= Player? E16= score#1
B17= Player? E17= score#2
B18= Player? E18= score#3

Any help is appreciated.

mm

[daffodil11]

Here you go. Just copy and paste the winners for game 1 into the other corresponding cells.

1st: =INDEX($A$3:$A$12,MATCH(LARGE(E$3:E$12,1),E$3:E$12,0))
2nd: =INDEX($A$3:$A$12,MATCH(LARGE(E$3:E$12,2),E$3:E$12,0))
3rd: =INDEX($A$3:$A$12,MATCH(LARGE(E$3:E$12,3),E$3:E$12,0))

daffodil example for madman1734.xlsx

Here's the formula logic:

Find the nth largest value in the range, find which row it's on, go to list of names, give me the name on that row.

[FDibbins]

Not sure which column/s you want to apply this to, so I used column D - adjust as needed...
=LARGE($D$3:$D$12,1)
That went into B24. I then used this, to pull in the name...
=INDEX($A$3:$A$12,MATCH(B24,$D$3:$D$12,0),1)

[madman1734]

Thank you for the help, both ways I can make work, however, I just thought of something...What if there is a tie score?