Rank uniquely - in order (if duplicate ranks exists)

Question

Rank uniquely - in order (if duplicate ranks exists)

Anonymous

Using a formula/function, I need to re-rank a list to avoid having duplicate rankings.

In B, I have a simple ranking order based on the person's score. I need a new column (Col A) with the corrected rankings that increases (by one based on sequential order) rather than repeat ranking as in Col B.

The first instance of 4 would be the first 4, second instance of 4 would automatically go up to 5, etc....

If there is a suggestion on how to eliminate needing Col B, and just rank col D to get results in A, I'm open to it.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

1 additional answer

Answer 1

Anonymous

Hi,

A2=RANK(D2,$D$2:$D$13,0)+COUNTIF($D$2:D2,D2)-1

Drag down

0 comments

Answer 2

Hello,

I am an independent advisor, and I am trying to help other users in Community with my experience in Microsoft products.

May I suggest that you check the link below, I think you will find it useful.

https://www.extendoffice.com/documents/excel/25...

Hope this helps.

Do let me know if you require any further help on this. Will be glad to help you.

Thank you

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Answer 3

Anonymous

Thanks!

When I make my first million....

I'm buying you a Krystal..... WITH cheese!

(...or White Castle burger if you prefer)

0 comments

Share via

Rank uniquely - in order (if duplicate ranks exists)

1 additional answer