View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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?