Help Find The Top 5

[MADx]

I am running a contest at work were we have four teams made of 9 people
We track 6 different items for each person, my sheet then calculate
there new total for each person. Off to the side I want to put a lis
of the top five people like below.

.............100........50......40......30......20......10......total
Stacey..................3........2......12................20.......790
Ryan....................5.................9..................7.......590


_top_five_people_
stacey <--------so fist I need to find the top score and then retur
the name
ryan <--------then I need to find the 2nd highest score and agai
return the name.


Thanks for any hel

 

[Biff]

Hi!

If there are no ties then it's fairly straightforward:

Names in column A, Totals in column H.

=INDEX(A$2:A$10,MATCH(LARGE(H$2:H$10,ROWS($1:1)),H$2:H$10,0))

If there are ties then it's a little more complicated. Post back if that's
the case.

Biff

 

[Biff]

P.S.

Copy the formula down as needed.

Biff

Hi!

If there are no ties then it's fairly straightforward:

Names in column A, Totals in column H.

=INDEX(A$2:A$10,MATCH(LARGE(H$2:H$10,ROWS($1:1)),H$2:H$10,0))

If there are ties then it's a little more complicated. Post back if that's
the case.

Biff