RANK problem, is there a limit?
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. |
RANK problem, is there a limit?
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. |
RANK problem, is there a limit?
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. |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com