View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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.