When you have duplicate entries each entry will be ranked differently
=RANK(F4,$F$4:$F$25)+COUNTIF($F$4:$F4,F4)-1

each duplicate entry will have the same ranking
=RANK(F4,$F$4:$F$25)


If this post helps click Yes
---------------
Jacob Skaria


"Jennifer" wrote:

I'm not sure if anyone can look at this formula and help explain but I am
trying to find the relevance of countif in this situation.

=RANK(F4,$F$4:$F$25)+COUNTIF($F$4:$F4,F4)-1

We are ranking "winners" and in this formula it is not accounting for a tie.
But when I take the count if function it is messing up a vlookup in another
column.

I appreciate any help.