View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anika Anika is offline
external usenet poster
 
Posts: 2
Default 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