How do I re-arrange numbers in a column?
=INDEX(A$1:A$4,COUNTA(A$1:A$4)-(ROWS($1:1)-1))*1000
Gord Dibben MS Excel MVP
On Tue, 20 Feb 2007 14:59:41 -0800, Cheetah
wrote:
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?
|