I have a few ranges, where I am using rank. I think that they are all
the same, except for the values being ranked.

This formula, results in a #NA for each value in the range:

=RANK(M2,$M$2:$M$178)+COUNTIF($M$2:M2,M2)-1

If I drop the $M$178 to $M$62, the formula works.
There are values in column M, from M2 down to M178, ranging from 185
down to 12.

Is there a limit in the number of values that RANK can evaluate?

The Second part is a countif that resolves the ties, so that in a 3
way tie, each value gets a different rank.

You will get #NA if there are blanks in your range.

" wrote:

I have a few ranges, where I am using rank. I think that they are all
the same, except for the values being ranked.

This formula, results in a #NA for each value in the range:

=RANK(M2,$M$2:$M$178)+COUNTIF($M$2:M2,M2)-1

If I drop the $M$178 to $M$62, the formula works.
There are values in column M, from M2 down to M178, ranging from 185
down to 12.

Is there a limit in the number of values that RANK can evaluate?

The Second part is a countif that resolves the ties, so that in a 3
way tie, each value gets a different rank.

On Sep 4, 4:28 pm, wrote:
I have a few ranges, where I am using rank. I think that they are all
the same, except for the values being ranked.

This formula, results in a #NA for each value in the range:

=RANK(M2,$M$2:$M$178)+COUNTIF($M$2:M2,M2)-1

If I drop the $M$178 to $M$62, the formula works.
There are values in column M, from M2 down to M178, ranging from 185
down to 12.

Is there a limit in the number of values that RANK can evaluate?

The Second part is a countif that resolves the ties, so that in a 3
way tie, each value gets a different rank.

Nevermind, there was a #NA in my list of values, that'll mess up my
ranks.