How do I re-arrange numbers in a column?
Thanks Elkar except I want to take that cell and multiply by 1000 so I was
hoping I can them in 1 step e.g. ig my nmbers were in A1..A4 I want to be
able to put them in column B where
cell B1=A4*1000
cell B2=A3*1000
cell B3=A2*1000
cell B4=A1*1000
rgds
jc
"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?
|