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? |
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 |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com