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