Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |