inverting a column of data
 

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.

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

"LCC" wrote:

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.

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

HTH

"LCC" wrote in message
...
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.

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" wrote in
message
...
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.


.

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

Thanks, anyway



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

"LCC" wrote:

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.

.