Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep a running 'Top five' in Excel?
I'd like to keep a running 'Top Five' in Excel. Attach names to values, and
list the top five names that the values are attached to. Eg: Mike - 5 Steve - 6 At the moment, the top value would be 6, so the cell would display 'Steve'. But if we add 2 points to Mike, the cell would automatically update to display 'Mike' as he has a higher value. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep a running 'Top five' in Excel?
you should first change the format i-e enter points in left column and names in right column (opposite to as you mentioned) suppose you have points in col A and names in col B (suppose which constitutes a range of A1:B10) then use the following functions to display the names having top five scores for top first =VLOOKUP(LARGE($A$1:$A$10,1),$A$1:$B$10,2,FALSE) for top second =VLOOKUP(LARGE($A$1:$A$10,2),$A$1:$B$10,2,FALSE) for top third =VLOOKUP(LARGE($A$1:$A$10,3),$A$1:$B$10,2,FALSE) for top fourth =VLOOKUP(LARGE($A$1:$A$10,4),$A$1:$B$10,2,FALSE) for top fifth =VLOOKUP(LARGE($A$1:$A$10,5),$A$1:$B$10,2,FALSE) hope this would help you. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=558779 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
question about some excel restriction script running on ... | Excel Discussion (Misc queries) | |||
question about some excel restriction script running on ... | Excel Discussion (Misc queries) | |||
I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
Running Excel events even in edit mode.... | Excel Discussion (Misc queries) |