In article ,
Morrigan
wrote:

The second part of Domenic's formula can be neglected as it will only
return zero.

ie.
=(SUMPRODUCT(--($A$1:$A$9=A1),--(B1<$B$1:$B$9))+1)

Actually, the second part of the formula is needed since the OP is
looking for unique ranking. See the OP's last post.