View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default generating rank-ordered list

Hi Jeffrey,

Say your names are in column D and scores are in column E.

Highlight both columns of data
Goto DataSort
Select sort by column E from the pulldown box
Check descending
Click OK

Any ties will retain their alphabetical order.

HTH
Martin