Hello Paulwelburn:

Assuming the names are in column A, range A2:A20 and their scores are in column B, range B2:B20.

Paste this formula in cell D2 and copy down to row 20.

=IF(B2="","",RANK(B2,B$2:B$20,1)+ROW()/100000)

Paste this formula in cell E2 and copy down to row 20.

=IF(ISERR(LARGE(D:D,ROW(1:1))),"",OFFSET(A$1,MID(LARGE(D:D,ROW(1:1)),FIND(".",LARGE(D:D,ROW(1:1))),6)*100000-1,0))

Paste this formula in cell F2 and copy down to row 20.

=IF(ISERR(LARGE(D:D,ROW(1:1))),"",OFFSET(B$1,MID(LARGE(D:D,ROW(1:1)),FIND(".",LARGE(D:D,ROW(1:1))),6)*100000-1,0))

Hide column D.

Matt