Top 5 high scores

[americanpie3]

Hello,

Is there a way to have a result of the top 5 highest scores? Here's my example.

Entered manually:

A1 = Dan - B1 = 63
A2 = Bill - B2 = 54
A3 = Steve - B3 = 73
A4 = Ben - B4 = 38
A5 = Patrick - B5 = 45
A6 = Jack - B6 = 104
A7 = Craig - B7 = 73

I put the tie on purpose because it can happen but not likely

So on D1 I wrote STANDINGS and E1 I put POINTS

So from D2 to D6 I want to formula to know that 104 is the high score and put the person's name and put the person's name the other column (E).

Thanks for your input.

 

[americanpie3]

OK. This is working great! Thank you.

I did run into 1 snafoo. For 1 ranking, there is 1 male that is in the female category. Your formulas worked for all stats wanted except for 1. I have 3x checked and the name has an M next to it. Not sure why his name pops up in the female category.

 

[Fluff]

It maybe because he is tied with one of the women. Try these instead.
In E2 =IFERROR(INDEX($A$1:$A$14,AGGREGATE(15,6,(ROW($A$1:$A$14)-ROW($A$1)+1)/(($B$1:$B$14=D2)*($C$1:$C$14="M")),COUNTIF(D$2:D2,D2))),"")
In G2 =IFERROR(INDEX($A$1:$A$14,AGGREGATE(15,6,(ROW($A$1:$A$14)-ROW($A$1)+1)/(($B$1:$B$14=F2)*($C$1:$C$14="F")),COUNTIF(F$2:F2,F2))),"")

Also please do not quote entire posts, as it just clutters up the thread.

 

[americanpie3]

You are correct. He does tie with another woman. I will try it and let you know

 

[americanpie3]

OK. This now solved the man who has the same score as the woman for the exact same score.

Now for the 2nd highest score, the next woman's name showed up, the 3rd is blank, 4th place is there and 5th place is blank.

3rd place is not tied with 2nd place but 4th and 5th are tied. I don't know if that makes a difference to you or not.

 

[Fluff]

Can you post the data that is not working?

 

[americanpie3]

There's a lot to post. What would you like to see exactly? The page onto which the formulas look for data? The results page?

 

[Fluff]

If there is a lot of data, would you be able to share the workbook?

 

[americanpie3]

Sure. let me know how.

 

[Fluff]

You will need to upload it to a share site such as OneDrive, DropBox, GoogleDrive. Then mark for sharing & post the link to the thread

 

[americanpie3]

Sure. Please send me a private message of the email address to share it to. I don't want to make the sheet public. If you want I can send you the sheet via email instead of putting in a dropbox.