Rank with Duplicate values

Hi,

Please see the attached file.

I want to rank column C based on column B. But column B as some duplicate values so I'm getting the same rank.
So for those duplicate values, I want to then check column A and decide the rank based on the higher %.

Eg: in column B, there is 2.45 three times. So instead of all getting rank 2, I want the one with highest % in column A to get rank 2.

Thanks for the help.

Ankit

Try this:

=COUNTIF($C$2:$C$18,">"&C2)+COUNTIFS($C$2:$C$18,C2,$B$2:$B$18,">"&B2)+1

Thank you. It works