View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tryn''''2learn
 
Posts: n/a
Default Ranking in order

Good afternoon,

I am trying to rank and place in order my findings. Example:

A B
1 2 Y
2 1 N
3 0 N/A

I have been able to get column C to display the highest number, but my
problem now is how do I get the name that ranks highest to be displayed.

in the above example it would be "Y" because it ranks highest.

thank you for your help