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