On rank, I have a list of numbers in column a1:a10 in column b i want rank
1-10, i try but when i drag equation it reference only from adjacent cell
(i.e. b4 will show rank of a4 within ref a4:a10, not a1:a1) Help please.

"mvlturner" wrote:

Thanks for responding, Nick. The formula started returning a N/A entry. But
now I have solved the problem, which resulted from a copying error: Excel was
attempting to evaluate a call using RANK with reference to an array that did
not include the cell itself. This is turn resulted from an error when a whole
line of data and formulae was copied at once by Excel, down to the line
below; so there is a mystery as to why the line should suddenly start to copy
erroneously . . . But never mind: the original problem is fixed!

Martin

"Niek Otten" wrote:

What does "stopped working" mean? What is your formula? What values?

--
Kind regards,

Niek Otten

"mvlturner" wrote in message ...
Is there there a limiting factor with RANK? For me, RANK has stopped working
after 1485 cases!