How do I re-arrange numbers in a column?
One way, using a macro:
Dim myArray()
Dim i As Long
Dim j As Long
myArray = Range("A1:A" & Range("A65536").End(xlUp).Row)
j = 1
For i = UBound(myArray) To LBound(myArray) Step -1
Range("A" & j) = myArray(i, 1)
j = j + 1
Next 'i
Change the column references as appropriate (A1 and A65536)
Regards
Trevor
"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?
|