Geoff F wrote:
Does anyone have experience in using the correction factor for tied ranks
when using the RANK function please?
I am finding the help on Microsoft online very confusing and I need to
somehow use only one of any tied returns when using RANK.
Thanks
It would help if you could elaborate on your objective...
=RANK(A2,$A$2:$A$25)+COUNTIF($A$2:A2,A2)-1
would assign distinct ranks to the scores in A2:A25.
|