View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default generating rank-ordered list

Are there any tie scores or are tie scores even a possibility?

Joe - 100
Sue - 110
Tom - 100

Biff

wrote in message
oups.com...
I have an alphabetical list of names and scores associated with them.
I would like to generate a list with these names in order of their
scores, but I can't seem to find how this is possible. I recently
found use of the "lookup" function, but it requires that the
"Lookup_vector" have data already sorted. Is there some way to take
care of this?