How do I re-arrange numbers in a column?

[Guest]

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?

 

[Guest]

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

 

[Bernard Liengme]

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

 

[Trevor Shuttleworth]

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

 

[T. Valko]

Use a temporary helper column:

Assume your data is in A1:A4

Enter this formula in B1:

=INDEX(A$1:A$4,COUNTA(A$1:A$4)-(ROWS($1:1)-1))

Copy down as needed.

Then you can convert the formulas to constants:

Select the range of formulas in column B.
Goto the menu Edit>Copy
Then, Edit>Paste Special>Values>OK

Then you can get rid of the original data.

Biff

 

[Guest]

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

 

[Gord Dibben]

=INDEX(A$1:A$4,COUNTA(A$1:A$4)-(ROWS($1:1)-1))*1000


Gord Dibben MS Excel MVP

 

[Guest]

In that case, try this formula in B1

=OFFSET($A$1,4-ROW(),0)*1000

Change the 4 to reflect the number of rows you have in column A. Copy the
formula down Column B as far as needed.

HTH,
Elkar