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


--
chris_manning
------------------------------------------------------------------------
chris_manning's Profile: http://www.excelforum.com/member.php...o&userid=23986
View this thread: http://www.excelforum.com/showthread...hreadid=386237

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.

chris_manning wrote:

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

--
chris_manning
------------------------------------------------------------------------
chris_manning's Profile: http://www.excelforum.com/member.php...o&userid=23986
View this thread: http://www.excelforum.com/showthread...hreadid=386237

--

Dave Peterson

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
news:chris_manning.1s0u6b_1121112318.3607@excelfor um-nospam.com...

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


--
chris_manning
------------------------------------------------------------------------
chris_manning's Profile:
http://www.excelforum.com/member.php...o&userid=23986
View this thread: http://www.excelforum.com/showthread...hreadid=386237

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!
==============================================



"Conrad Carlberg" wrote in message
k.net...
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
news:chris_manning.1s0u6b_1121112318.3607@excelfor um-nospam.com...

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


--
chris_manning
------------------------------------------------------------------------
chris_manning's Profile:
http://www.excelforum.com/member.php...o&userid=23986
View this thread:
http://www.excelforum.com/showthread...hreadid=386237