software

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

What does quot;stopped workingquot; mean? What is your formula? What values?

--
Kind regards,

Niek Otten

quot;mvlturnerquot; gt; wrote in message ...
gt; Is there there a limiting factor with RANK? For me, RANK has stopped working
gt; after 1485 cases!
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

quot;Niek Ottenquot; wrote:

gt; What does quot;stopped workingquot; mean? What is your formula? What values?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;mvlturnerquot; gt; wrote in message ...
gt; gt; Is there there a limiting factor with RANK? For me, RANK has stopped working
gt; gt; after 1485 cases!
gt;
gt;
gt;

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.

quot;mvlturnerquot; wrote:

gt; Thanks for responding, Nick. The formula started returning a N/A entry. But
gt; now I have solved the problem, which resulted from a copying error: Excel was
gt; attempting to evaluate a call using RANK with reference to an array that did
gt; not include the cell itself. This is turn resulted from an error when a whole
gt; line of data and formulae was copied at once by Excel, down to the line
gt; below; so there is a mystery as to why the line should suddenly start to copy
gt; erroneously . . . But never mind: the original problem is fixed!
gt;
gt; Martin
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; What does quot;stopped workingquot; mean? What is your formula? What values?
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;mvlturnerquot; gt; wrote in message ...
gt; gt; gt; Is there there a limiting factor with RANK? For me, RANK has stopped working
gt; gt; gt; after 1485 cases!
gt; gt;
gt; gt;
gt; gt;

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

quot;tonyquot; wrote:

gt; On rank, I have a list of numbers in column a1:a10 in column b i want rank
gt; 1-10, i try but when i drag equation it reference only from adjacent cell
gt; (i.e. b4 will show rank of a4 within ref a4:a10, not a1:a1) Help please.
gt;
gt; quot;mvlturnerquot; wrote:
gt;
gt; gt; Thanks for responding, Nick. The formula started returning a N/A entry. But
gt; gt; now I have solved the problem, which resulted from a copying error: Excel was
gt; gt; attempting to evaluate a call using RANK with reference to an array that did
gt; gt; not include the cell itself. This is turn resulted from an error when a whole
gt; gt; line of data and formulae was copied at once by Excel, down to the line
gt; gt; below; so there is a mystery as to why the line should suddenly start to copy
gt; gt; erroneously . . . But never mind: the original problem is fixed!
gt; gt;
gt; gt; Martin
gt; gt;
gt; gt; quot;Niek Ottenquot; wrote:
gt; gt;
gt; gt; gt; What does quot;stopped workingquot; mean? What is your formula? What values?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Kind regards,
gt; gt; gt;
gt; gt; gt; Niek Otten
gt; gt; gt;
gt; gt; gt; quot;mvlturnerquot; gt; wrote in message ...
gt; gt; gt; gt; Is there there a limiting factor with RANK? For me, RANK has stopped working
gt; gt; gt; gt; after 1485 cases!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;