Or if you know what the last row will be, this is easier to type.

=INDEX($A:$A,5-(ROW(A1)-1))

Change the 5 to last row number.


Gord Dibben MS Excel MVP

On Thu, 15 Jan 2009 05:44:12 -0800, Gary''s Student
wrote:

To invert a column, in B1 enter:

=INDEX(A:A,LOOKUP(2,1/($A$1:$A$65535<""),ROW($A$1:$A$65535))-ROWS(B$1:B1)+1)

and copy down