View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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