You are right. That takes care of the duplicates. Sorry for my minimal
excel knowledge. ;)



Domenic Wrote:
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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390190