Thread: rank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
drofdel drofdel is offline
external usenet poster
 
Posts: 2
Default rank

.. "I'm trying to use the RANK function to sort the values in Column A, but,
the problem arises when I have two or more cells with the same value. Then,
the RANK also repeats some positions. For example, if I have, 50, 60, 62, 62,
67 in Column A I would get 5,4,2,2,1 in Column B. Is there a way I can get
5,4,2.5,2.5,1 ?"