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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Should cover it

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

--

Regards,

Peo Sjoblom


Craig D. said:
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
Click to expand...
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).
 
Back
Top