Multiple Criteria Ranking without Duplicates

[ejsifuen1124]

Please help! I've tried so many different things and have had no success. That said, I'm sure I'm missing something simple. I'd like to set up a ranking column based on multiple criteria where ties skip a number and there are no duplicate rankings. Right now my formula gives the same ranking for the same value (views it as a tie and ranks it as such).

Here's what I'm using:

=COUNTIFS(D:D,D2,H:H,">"&H2)+1

Column D - groups
Column H - value that is being ranked

Looking to consecutively rank column H, based on column D's group, without duplicates/ties! Example of desired outcome:

Group	Value	Rank
Orange	12	2
Orange	15	1
Red	13	1
Blue	17	1
Orange	12	3
Red	11	2
Blue	10	2

Any help is greatly appreciated and hope everyone has happy holidays.

 

[Fluff]

How about
=COUNTIFS(D:D,D2,H:H,">"&H2)+COUNTIFS(D$2:D2,D2,H$2:H2,"="&H2)

 

[ejsifuen1124]

This works perfectly! Thanks so much for the help.

 

[Fluff]

You're welcome & thanks for the feedback