I
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
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