How do you rank in order numbers from highest to the lowest?
Thank you. It works brilliantly!
"RagDyer" wrote:
With data in A2 to A8, enter this in B2, and copy down:
=RANK(A2,$A$2:$A$8)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anika" wrote in message
...
For Example
How would I rank these numbers in order from highest to the lowest
Current Points Current Place
46
48
44
44.5
48
44
44
|