In B2 enter & copy down as far as needed:

=INDEX($A$2:$A$4,ROWS($A$2:$A$4)-(ROW()-ROW(B$2)))

D wrote:
I have a long colum on numbers, I would like to put them in reverse order.

i.e. A2 has 101
A3 has 103
A4 has 105

Reversed to:
A2 105
A3 103
A4 101

Etc.

Thanks

Don

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.