To invert a column, in B1 enter:

=INDEX(A:A,LOOKUP(2,1/($A$1:$A$65535<""),ROW($A$1:$A$65535))-ROWS(B$1:B1)+1)

and copy down
--
Gary''s Student - gsnu200826


"Bobby" wrote:

I word my problem wrong. Here's it again.

"Bobby" wrote:

I have a column formatted as text, I want to reverse the numbers around
a1 9 a1 12
a2 5 a2 1
a3 7 will look like this a3 7
a4 1 a4 5
a5 12 a5 9

assending / desending isn't what I'm lookin for.
Thanks Bob