View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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