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
|