Ranking like values the same, but not omitting the next rank number?

[RINCONPAUL]

Rank formulas treat equal values as the same rank normally. Then the next value (descending or ascending) increases by the count of the like values. I'm after a formula to insert in col C that firstly recognises the change in subset data (col A), ranks the data sequentially with no gaps or rank numbers missing.
Thanks.

[Bob Phillips]

Try this array formula


=COUNT(1/FREQUENCY(IF($A$2:$A2=A2,IF($B$2:$B2<>"",$B$2:$B2)),IF($A$2:$A2=A2,IF($B$2:$B2<>"",$B$2:$B2))))

[RINCONPAUL]

Thanks xld, it kinda works, but can't differentiate between different subsets in col A and restart rank at '1' for next subset. Need an array formula I'd suggest?

[Bob Phillips]

It is an array formula, and it does.

[RINCONPAUL]

Whoops, apologies, I should've recognised it as such, and hit Ctrl Shift Enter. Thanks so much xld :hi: