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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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?