Tie records in RANK
 

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

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.

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.

Aladin

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

You have saved me a few sleepless nights!

Cheers

"Aladin Akyurek" wrote:

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.