Help Find The Top 5
 

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 calculates
there new total for each person. Off to the side I want to put a list
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 return
the name
ryan <--------then I need to find the 2nd highest score and again
return the name.


Thanks for any help


--
MADx
------------------------------------------------------------------------
MADx's Profile: http://www.excelforum.com/member.php...o&userid=37687
View this thread: http://www.excelforum.com/showthread...hreadid=572928

Help Find The Top 5
 

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

"MADx" wrote in message
...

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 calculates
there new total for each person. Off to the side I want to put a list
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 return
the name
ryan <--------then I need to find the 2nd highest score and again
return the name.


Thanks for any help


--
MADx
------------------------------------------------------------------------
MADx's Profile:
http://www.excelforum.com/member.php...o&userid=37687
View this thread: http://www.excelforum.com/showthread...hreadid=572928

Help Find The Top 5
 

P.S.

Copy the formula down as needed.

Biff

"Biff" wrote in message
...
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

"MADx" wrote in
message ...

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 calculates
there new total for each person. Off to the side I want to put a list
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 return
the name
ryan <--------then I need to find the 2nd highest score and again
return the name.


Thanks for any help


--
MADx
------------------------------------------------------------------------
MADx's Profile:
http://www.excelforum.com/member.php...o&userid=37687
View this thread:
http://www.excelforum.com/showthread...hreadid=572928