View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Jeffrey.Chienhua.Chu@gmail.com is offline
external usenet poster
 
Posts: 2
Default generating rank-ordered list

yes, but they are very unlikely

Biff wrote:
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?