How do you rank in order numbers from highest to the lowest?

Guest · Sep 13, 2006

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

Guest · Sep 13, 2006

Using the "Large" function - "=Large( array, 2 )" will return the second
largest number in the array.

Regards,
Bill

RagDyer · Sep 13, 2006

With data in A2 to A8, enter this in B2, and copy down:

=RANK(A2,$A$2:$A$8)

Guest · Sep 13, 2006

Thank you. It works brilliantly!

RagDyer said:
With data in A2 to A8, enter this in B2, and copy down:

=RANK(A2,$A$2:$A$8)

Guest · Sep 13, 2006

If you don't want the duplicates ranked the same
=RANK(A2,A$2:A$10)+COUNTIF(A$2:A2,A2)-1