Hi,

I can't see the logic in your reversing the rank of 60 & 70 s0 assume that's
a typo, try this

=SUMPRODUCT(--(A1<$A$1:$A$10),1/COUNTIF($A$1:$A$10,$A$1:$A$10&""))+1

Mike

"Ms-Exl-Learner" wrote:

Hi All,

I need to use the rank function for the below example

A Column B Column C Column
Total Formula Rank Desired Rank
20 8 1
40 7 1
20 8 1
60 5 2
80 3 3
20 8 3
88 2 4
60 5 5
70 4 6
90 1 7

Here A column Consist the Total and I want to apply the rank function for
the A Column Value when I use this formula =RANK(A2,$A$2:$A$11) in B2 Cell
and drag it upto B11 Cell then I am getting the above results. But I require
the results as per the C Column.

Please guide me how it can be done.

Thanks for reading and waiting for your valuable reply.

--------------------
(Ms-Exl-Learner)
--------------------