Inverting the contents of a column question

[Guest]

In Excel I have a column that has a word in each cell from cells A1 to A20. How can I invert this column of words, for example into column B so that the contents of A1 fills B20 and A2 fills B19 etc.

Thanks.

 

[Frank Kabel]

hi
enter the following formula in A1
=OFFSET($B$20,-(ROW(1:1)-1),0)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

In Excel I have a column that has a word in each cell from cells A1

to A20. How can I invert this column of words, for example into column
B so that the contents of A1 fills B20 and A2 fills B19 etc.

 

[Jason Morin]

Try this in B1 and fill down:

=OFFSET($A$1,COUNTA(A1:$A$20)-1,)

HTH
Jason
Atlanta, GA

-----Original Message-----
In Excel I have a column that has a word in each cell

from cells A1 to A20. How can I invert this column of
words, for example into column B so that the contents of
A1 fills B20 and A2 fills B19 etc.