RANK problem, is there a limit?

M

mark.wolven

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

mark.wolven

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank Error in Pivot Table 2
How to break ties in Rank by specified criteria? 0
Rank based on 2 categories 6
Rank Formula 1
Ranking in a Different Way 12
rank 2
Rank based on category 3
Rank order with conditions 3

Top