Data Order Reversal

[chris_manning]

Hi All-

Quick question, is it possible to copy a column of data and then 'flip'
the data so it is in reverse order, such that the last data point in the
initial column is the first data point in the new column? Any help is
appreciated.

Chris

 

[Dave Peterson]

I'd copy to that new worksheet.

Then insert a helper column with 1,2,3,4, ... in that column.

Then sort your data by that column--but sort it descending.

then delete the helper column.

 

[Conrad Carlberg]

Here's a way that uses a formula, so your reversed range will update if you
change data in the original range.

Suppose your original data are in A1:A10. In, say, C1, enter this formula:

=OFFSET($A$1,ROWS($A$1:$A$10)-ROW(),0)

and copy-and-paste it into C2:C10.

The formula would require some adjustment if either your original or
reversed range begins in other than row 1.

C^2
Conrad Carlberg

"chris_manning" <[email protected]>
wrote in message
news:[email protected]...

 

[RagDyer]

And here's one that's not volatile:

INDEX($A$1:$A$20,20-(ROW(A1)-1))
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Here's a way that uses a formula, so your reversed range will update if you
change data in the original range.

Suppose your original data are in A1:A10. In, say, C1, enter this formula:

=OFFSET($A$1,ROWS($A$1:$A$10)-ROW(),0)

and copy-and-paste it into C2:C10.

The formula would require some adjustment if either your original or
reversed range begins in other than row 1.

C^2
Conrad Carlberg

"chris_manning"

wrote in message