See
Ranking
http://www.tushar-mehta.com/excel/ne...ing/index.html
in particular the section 'Retain duplicate values but create
continuous ranks, i.e., no breaks in the rank.'

On Sun, 25 Oct 2009 08:24:01 -0700, Ms-Exl-Learner
wrote:

Sorry for the inconvenience, Please ignore my previous example, since I have
mentioned wrong Values in the Desired Rank (C Column).

This is the correct one.

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

Thank you,

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



"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)
--------------------
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins