How do I re-arrange numbers in a column?
Insert a helper column next to your column of numbers
In the first cell of this helper column, enter 1, then 2.... fill down as
far as needed
Sort all of your data using the helper column (in descending order)
Delete the helper column
HTH,
Elkar
"Cheetah" wrote:
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?
|