Inverting a column

Is it possible to invert a column of numbers, so that the
top number is at the bottom, and the bottom number is at
the top?

If your existing Column Data is in Column E (say E2:E21) in Column F (Insert
if necessary) enter into cell F2 and Copy Down to F21:

=OFFSET(E$2,COUNTA(E$2:E$21)+1-ROW(),0,1,1)


"Joe" wrote in message
...
Is it possible to invert a column of numbers, so that the
top number is at the bottom, and the bottom number is at
the top?

Hi Joe,

Select one of the cells in the column and then click on Data and then Sort.
There is also an icon on the toolbar which will do this for you. This will
sort A-Z or 1-9 or the reverse.

Best Regards,

CalumMurdo Kennedy
www.taekwondo.freeserve.co.uk


"Joe" wrote in message
...
Is it possible to invert a column of numbers, so that the
top number is at the bottom, and the bottom number is at
the top?