View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I re-arrange numbers in a column?

How about adding a helper column with numbers 1,2,3... - very easy and quick
to do
Now sort in descending the two columns using the new column as the key
The helper column can be deleted when you are done.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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?