Conditional Rank Troubleshooting

[iperlovsky]

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

 

[Bernd P]

Hello,

Have a look at my more complex example on
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd