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?

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