Top 5 List with Corresponding Team Name

**AWat** · 07-19-2011, 03:28 PM

I have an excel sheet for a charity bass tournament. In rows B5-B35 I have the team names listed. In rows L5-L35 the total fish weight is listed.

I would like to have a way to display the top 5 teams and the total fish weight. I haven't quite figured out how exactly to do this. Any help would be appreciated!

**alansidman** · 07-19-2011, 03:37 PM

Apply the Large function

http://www.techonthenet.com/excel/formulas/large.php

Alan

**ChemistB** · 07-19-2011, 03:40 PM

Lets' say you're putting your top 5 in M1:M5 with weights in N1:N5

In N1
=LARGE($L$5:$L$35,ROW(A1)) dragged down
In M1
=INDEX($B$5:$B$35,MATCH(N1,$L$5:$L$35,0))
This only works if there are no ties. But it will be obvious, you'll see the same team name twice.

**AWat** · 07-19-2011, 03:47 PM

Originally Posted by ChemistB

Lets' say you're putting your top 5 in M1:M5 with weights in N1:N5

In N1
=LARGE($L$5:$L$35,ROW(A1)) dragged down
In M1
=INDEX($B$5:$B$35,MATCH(N1,$L$5:$L$35,0))
This only works if there are no ties. But it will be obvious, you'll see the same team name twice.

Works great, thought I had an issue but simple error on my part. Thanks for both of your help!