View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default to reverse a column

The easiest way is probably to add a helper column alongside with numbers
from 1 to N.
Select the two columns, & sort by your second column in descending order,
then you can delete your helper column.
--
David Biddulph


"Rasoul Khoshravan" wrote in message
...
I have a column of data.
I want to reverse it. Is it possible?

as
ab
ad

change to
ad
ab
as