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.