Count if
 

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.

Count if
 

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.

Count if
 

I figured it out.


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

Count if
 

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?








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