Invert data order
 

I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the
top and the top data to be at the bottom. Any suggestions? Thanks a lot.
Ibone

Invert data order
 

let's say we have data in A1 thru A30. In an un-used column enter:

=INDIRECT("A" & 31-ROW())

and copy down. Then take the helper column, copy it, and
paste/special/value back onto column A
--
Gary's Student
gsnu200704


"Ibone" wrote:

I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the
top and the top data to be at the bottom. Any suggestions? Thanks a lot.
Ibone

Invert data order
 

=INDEX($A$2:$A$100,ROWS($A$2:$A$100)-ROWS($1:1)+1)


"Ibone" wrote:

I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the
top and the top data to be at the bottom. Any suggestions? Thanks a lot.
Ibone

Invert data order
 

put in a helper column
enter 1,2 in the column to the end of the data
Select the two columns and sort on the helper column desending
delete the helper column

"Ibone" wrote:

I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the
top and the top data to be at the bottom. Any suggestions? Thanks a lot.
Ibone