| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy values separated by a set number of columns
Posted this in response to one of your earlier repeat queries 3 - 4 days ago:
----------------------- ..copy the value for A3, then C3, and E3 for all the planned results. Assuming source data as posted in Sheet1 In another sheet, Put this in any start cell, eg in B2: =OFFSET(Sheet1!$A$3,,ROWS($1:1)*2-2) Copy down to return as desired Click YES below if it helped -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
| copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
| Copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
| Copy columns values into separate columns | Excel Discussion (Misc queries) | |||
| Copy/Paste of separated columns | Excel Discussion (Misc queries) | |||
Threaded Mode
