View Single Post
 
Old 02-05-2010, 12:24 PM
FraserKitchell FraserKitchell is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2009
Posts: 21
FraserKitchell is on a distinguished road
Default

Assuming the person's name is located next to the score (in column B), and the list is A1:A5 as above, you'll need to use a vlookup. First get the max score in a cell (formula : =max(A1:A5); put this cell in C1

Then use a vlookup, (formula : =vlookup(C1, A1:B5, 2, False)

Thanks
Reply With Quote