Data Order Reversal

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

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" <chris_manning.1s0u6b_1121112318.3607@excelforum-nospam.com>
wrote in message
news:chris_manning.1s0u6b_1121112318.3607@excelforum-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" <carlbergc@earthlink.net> wrote in message
news:JFCAe.2212$dU3.83@newsread2.news.pas.earthlink.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"
<chris_manning.1s0u6b_1121112318.3607@excelforum-nospam.com>
> wrote in message
> news:chris_manning.1s0u6b_1121112318.3607@excelforum-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
> >
>
>