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!
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
