Hi!

Suppose you want to invert A1:C10

In D1 enter this formula:

=ROW()

Double click the fill handle to copy the formula through D10

Select the range, A1:D10 then sort on column D descending.

After your done delete he formulas in column D.

Biff

"bamboo" wrote in
message ...

i have to like invert several colums... i dont know how to do that
without retyping the whole thing, is there another way?


--
bamboo
------------------------------------------------------------------------
bamboo's Profile:
http://www.excelforum.com/member.php...o&userid=26721
View this thread: http://www.excelforum.com/showthread...hreadid=399753