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