ID top 5 high scores and associated team names from a table

[thebutlerdidit]

Hello, this is thebutlerdidit having trouble with a game scoring spreadsheet.

What I have: A spreadsheet with 30 teams (named in col B) and their total scores (in col A).

Objective: ID top 5 Teams and their scores. (If multiple teams are tied with high score, I'm ok listing the top 5 teams in order they appear in list, even if there are >5 with same score.)

What's happening: If multiple teams have the same high score, the first team name noted in the list gets noted multiple times. Example: if Teams A, B, C have high score of 5, and teams D and E have scores of 4 and 2, team A will be listed 3 times as having 5 points, team D will be listed with 4 points and team E will be listed as having 2 points. (If both teams D and E have 2 points, then team D will be listed twice as having 2 points.)

NOTE: It doesn't appear I can upload my file using the computer I'm on.

Equation I'm using to ID Team Names having top 5 scores:

=IF(M6>0,VLOOKUP(LARGE(A3:A30,1),A3:B30,2,FALSE),"TBD")
• Col M is for top 5 high scores. If value is "0", then "TBD" is noted in Col L where Team name will go if Col M value >0)
• VLOOKUP finds the highest score in Col A, as signified by the "1" in parenthesis after "LARGE". The subsequent rows have 2, 3, 4, 5 in that position.

[José Augusto]

Try this approach

A2:A31 has a total score, B2:B31 has time names and F2:F6 has the values 1 to 5

Use in G2 the following array formula

Please Login or Register  to view this content.

Note: array formula must be enter with CTRL+SHIFT+ENTER

See the file

[thebutlerdidit]

FANTASTIC!!!! This worked PERFECTLY! Thank you! Thank you! Now, how do I closed this out, say it's solved and rate you with the highest rating?