View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default to reverse a column

In an adjacent column enter the numbers 1 to whatever.

Select both columns and sort on that column in descending order.


Gord Dibben MS Excel MVP

On Fri, 20 Oct 2006 00:22:49 +0900, "Rasoul Khoshravan"
wrote:

I have a column of data.
I want to reverse it. Is it possible?

as
ab
ad

change to
ad
ab
as