| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flip columns of data
Hi,
I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip columns of data
Select your data, then Data/ Sort / left to right/ descending.
And if you have 0 to 32, that would be 33 columns, not 32. -- David Biddulph wrote in message ups.com... Hi, I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip columns of data
Thanks. I can;t realize I never knew that though I am so familiar with
excel. Thanks for your help Swamy On Apr 6, 5:06 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Select your data, then Data/ Sort / left to right/ descending. And if you have 0 to 32, that would be 33 columns, not 32. -- David Biddulph wrote in message ups.com... Hi, I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip columns of data
You can also use a formula, and make a *reverse copy* of your data, leaving
the original data untouched. With data in A1 to AG1, (and that's 33 cells, not 32), enter this formula *anywhere*, and drag across 33 columns: =INDEX($A$1:$AG$1,33-(COLUMN(A1)-1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... Thanks. I can;t realize I never knew that though I am so familiar with excel. Thanks for your help Swamy On Apr 6, 5:06 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Select your data, then Data/ Sort / left to right/ descending. And if you have 0 to 32, that would be 33 columns, not 32. -- David Biddulph wrote in message ups.com... Hi, I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip columns of data
Thanks for your help
Swamy On Apr 6, 5:29 pm, "Ragdyer" wrote: You can also use a formula, and make a *reverse copy* of your data, leaving the original data untouched. With data in A1 to AG1, (and that's 33 cells, not 32), enter this formula *anywhere*, and drag across 33 columns: =INDEX($A$1:$AG$1,33-(COLUMN(A1)-1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! wrote in message ups.com... Thanks. I can;t realize I never knew that though I am so familiar with excel. Thanks for your help Swamy On Apr 6, 5:06 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Select your data, then Data/ Sort / left to right/ descending. And if you have 0 to 32, that would be 33 columns, not 32. -- David Biddulph wrote in message roups.com... Hi, I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip columns of data
You're very welcome.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... Thanks for your help Swamy On Apr 6, 5:29 pm, "Ragdyer" wrote: You can also use a formula, and make a *reverse copy* of your data, leaving the original data untouched. With data in A1 to AG1, (and that's 33 cells, not 32), enter this formula *anywhere*, and drag across 33 columns: =INDEX($A$1:$AG$1,33-(COLUMN(A1)-1)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- wrote in message ups.com... Thanks. I can;t realize I never knew that though I am so familiar with excel. Thanks for your help Swamy On Apr 6, 5:06 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Select your data, then Data/ Sort / left to right/ descending. And if you have 0 to 32, that would be 33 columns, not 32. -- David Biddulph wrote in message roups.com... Hi, I have 32 columns of data numbered from 0 -32. What I would like to do is to flip those data starting from 32 to 0. Is there a way to do this rather than performing some basic cut and paste? Thanks Mahadevan Swamy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I flip a list of data ie invert it? | Excel Discussion (Misc queries) | |||
| Images inside . . I need to Flip Columns, to Rows & Visa Versa?? SIMPLE RIGHT? :( | Excel Discussion (Misc queries) | |||
| How dio you flip a worksheet that the columns start on the right | Excel Discussion (Misc queries) | |||
| How dio you flip a worksheet that the columns start on the right | Excel Discussion (Misc queries) | |||
| want to flip data in an excel column so last is first, first is l. | Excel Discussion (Misc queries) | |||
Hybrid Mode
