How do I re-arrange numbers in a column?
Use a temporary helper column:
Assume your data is in A1:A4
Enter this formula in B1:
=INDEX(A$1:A$4,COUNTA(A$1:A$4)-(ROWS($1:1)-1))
Copy down as needed.
Then you can convert the formulas to constants:
Select the range of formulas in column B.
Goto the menu EditCopy
Then, EditPaste SpecialValuesOK
Then you can get rid of the original data.
Biff
"Cheetah" wrote in message
...
In a column I have for e.g. numbers
234
111
333
888
but I want to re-arrange them so that the bottom # goes to the top & vice
versa i.e.
888
333
111
234
How do I do this in excel?
|