Assuming Column A is name and Column B is points

Highlight Column A and Column B and then click on _D_ata, _S_ort...
Sort by Points _D_escending, then by Name As_c_ending

Then on somewhere else on your sheet put the following (I put it in
D1:D4)

D1 is Current leaders a
D2 is =A2 & " on " & B2 & " points"
D3 is =A3 & " on " & B3 & " points"
D4 is =A4 & " on " & B4 & " points"


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548615