Reversing a column. How?
You could use =(OFFSET(A$1,50-ROW(),0)) in row 1, and copy that down.
--
David Biddulph
wrote in message
.. .
How do I reverse the order of items in a column? I have a column of
50 numbers. How do I create a new column of numbers so that the first
number in the new column is the last number in the old column and the
last number of the new column is the first number in the old column?
Is there an easy way to do this?
|