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