i used

CellD1=

=SUMPRODUCT((B$2:B$10=B2)*(C$2:C$10C2))+1

but it returns the same rank for same values

do you know how to assign different rank for Sumproduct formula

thanks in advance


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=542083