View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Can I reverse the order of data in a set of cells?

One way, insert a new column or use an existing, number it from
1 - n (where n is the last index value you want to reverse the order of,
so if your column is 100 rows number the help column 1, 2, 3 - 100)
select both columns and sort descending on the help column


--

Regards,

Peo Sjoblom

"salwitt" wrote in message
...
I have a column of cells filed with data. I know I can transpose the data

90
degrees, but is there a way to cut or copy the data in the cells and paste

it
so the values are in the opposite order, i.e. a 180 degree difference?
Thanks to anyone who can help.

I am using Excel 2003.