VERY clever Niek..........it led me to this little modification.......

=IF(A1<"",INDEX($A$1:$A$50,COUNTA(A:A)+1-ROW()),"")

Vaya con Dios,
Chuck, CABGx3





"Niek Otten" wrote:

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