Using a formula:

=INDEX(A$1:A$1000,ROWS(A1:A$1000))

Copy down


--
Biff
Microsoft Excel MVP


"Steven Sinclair" wrote in
message ...
I have a column of 1000 items.

I would like to be able to "reverse" the current order of the column, but
cannot use the sort feature as I have numbers mixed with text. Every time
I
attempt to use the sort feature, everything is all messed up.

So if I have this...

a
1
2
b
3
4
5
c

I need this...

c
5
4
3
b
2
1
a

How can I accomplish this programmatically?

Thanx.