Tie records in RANK

[Geoff F]

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

 

[Aladin Akyurek]

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.

 

[Aladin Akyurek]

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.

 

[Geoff F]

Aladin

Thank you very much. That is exactly what I needed.

You have saved me a few sleepless nights!

Cheers