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.

.