Are there any suggestions for troubleshooting the following (conditional
rank)formula, which is not properly correcting for tied ranks as I think it
should (ie, it is assigning the same rank more than once)?

{=SUMPRODUCT(($A$5:$A$1000=A100)*IF(ISNUMBER($B$5: $B$1000),$B$5:$B$1000-ROW($B$5:$B$1000)/1E9=B100-ROW(B100)/1E9))}

Thanks,

IP