Reversing a column. How?

[Guest]

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?

 

[Niek Otten]

=INDEX($A$1:$A$50,51-ROW())
Copy down

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?

 

[David Biddulph]

You could use =(OFFSET(A$1,50-ROW(),0)) in row 1, and copy that down.