How to get unique rank numbers when two or more items rank the same.

[Guest]

My question is below the example. Many thanks for the assistance.


Initial Example:

Data Item Rank (Using 'Rank' Function)
------------ ---------------------------------

100% 1
100% 1
50% 5
75% 4
100% 1


All I'm looking to do is get unique Rank numbers even when there are items that tie for a ranking position (as #1 does in my above example). I have no preference for the unique rank number given to the data elements that tie, so my second example is all I'm hoping to achieve as an out come. (* Note: If it takes more than the 'Rank' function to achieve this, that's fine too).


2nd Example:

Data Item Rank (Using 'Rank' Function)
------------ ---------------------------------

100% 1
100% 2
50% 5
75% 4
100% 3

 

[Frank Kabel]

Hi
if your data is in A1:A5 try the following formula in B1
=RANK(A1,$A$1:$A$5)+COUNTIF($A$1:$A1,A1)-1
and copy down
You may also have a look at
http://www.cpearson.com/excel/rank.htm

 

[Peo Sjoblom]

Should cover it

http://www.cpearson.com/excel/rank.htm

--

Regards,

Peo Sjoblom

My question is below the example. Many thanks for the assistance.


Initial Example:

Data Item Rank (Using 'Rank' Function)
------------ ---------------------------------

100% 1
100% 1
50% 5
75% 4
100% 1


All I'm looking to do is get unique Rank numbers even when there are items

that tie for a ranking position (as #1 does in my above example). I have no
preference for the unique rank number given to the data elements that tie,
so my second example is all I'm hoping to achieve as an out come. (* Note:
If it takes more than the 'Rank' function to achieve this, that's fine too).