M
mvlturner
Is there there a limiting factor with RANK? For me, RANK has stopped working
after 1485 cases!
after 1485 cases!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
What does "stopped working" mean? What is your formula? What values?
M
mvlturner
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
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
T
tony
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.
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.
M
mvlturner
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
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