inverting a column of data

[LCC]

Hi! Everyone,

I have a column of numerical data entered in (say)
A1.A100. How can I reverse their order, i.e to have value
in A100 to be in B1, A99 in B2, ... and A1 in B100?

Appreciate any helps.

 

[Guest]

Hi
in B1 enter
=OFFSET($A$100,-(ROW()-1),0)
and copy down

 

[Jim May]

In B1 enter =OFFSET($A$1,COUNT(A1:$A$100)-1,0)
and copy down to B100

HTH

 

[LCC]

Thanks, HTH

It works well with me.

-----Original Message-----
In B1 enter =OFFSET($A$1,COUNT(A1:$A$100)-1,0)
and copy down to B100

HTH




.

 

[LCC]

There seems to be problem. It can only invert the first
three data.

Thanks, anyway