Limitations of RANK
 

Is there there a limiting factor with RANK? For me, RANK has stopped working
after 1485 cases!

Limitations of RANK
 

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!

Limitations of RANK
 

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!

Limitations of RANK
 

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!

Limitations of RANK
 

You need to edit the formula to reflect the range of values you want to rank.
If copying, first make the range absolute by pressing F4 when the cursor if
just to the lefy of the cell reference; otherwise Excel will tyranspose the
range accordingly when you copy to another location.

Kind regards

Martin

"tony" wrote:

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!