Count if

[Jennifer]

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.

 

[Jacob Skaria]

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

 

[Jennifer]

I figured it out.

 

[Patrick Molloy]

the coundIF ranks the same number

eg
if your list was say 4,5,4,2,1 the rank would be 2,1,2,4,5
since the two 4's take up 3rd and 2nd , ie rank equally second
the COUNTIF ajsuts the rank of the 4'd buy counting if there was one ahead
so the first 4 , nothing ahead, gets a rank of 2
the 2nd 4 , also gets a rank of 2, but there's one 4 alreay counted, so 2+1
= 3

if i change the list to 4,5,4,2,4
the rank is 2,1,2,5,2
the count if
is
2(2+0),1,3(2+1),5,4(2+2)

is this clear?