| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy cells in a specific pattern
Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform
this into weekly data (starting on mon). My solution for this was to create a column with the following pattern: A1 A6 A11 And use the fill pattern to complete all 1000 observations. My problem is that Ecxel is not continuing my pattern, but starts over after 3 observations: A2 A7 A12 A3 A8 A13 and so on... I don't want it to follow this pattern, but just continue... Can anyone help me with this problem? - Cornelius |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy cells in a specific pattern
Assuming your original data is on 'Sheet1', and begins at row 1 as per your
example, then on the other sheet, enter this formula in a cell on row 1: =OFFSET(Sheet1!A$1,(ROW()-1)*5,0) and fill it down the sheet. It will pick up A1, A6, A11, A16, A21, etc. from Sheet1 "Cornelius" wrote: Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform this into weekly data (starting on mon). My solution for this was to create a column with the following pattern: A1 A6 A11 And use the fill pattern to complete all 1000 observations. My problem is that Ecxel is not continuing my pattern, but starts over after 3 observations: A2 A7 A12 A3 A8 A13 and so on... I don't want it to follow this pattern, but just continue... Can anyone help me with this problem? - Cornelius |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy cells in a specific pattern
Another option
Place in any starting cell, eg in C2: =INDEX(A:A,ROWS($1:1)*5-4) Copy C2 down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cornelius" wrote: Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform this into weekly data (starting on mon). My solution for this was to create a column with the following pattern: A1 A6 A11 And use the fill pattern to complete all 1000 observations. My problem is that Ecxel is not continuing my pattern, but starts over after 3 observations: A2 A7 A12 A3 A8 A13 and so on... I don't want it to follow this pattern, but just continue... Can anyone help me with this problem? - Cornelius |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy cells in a specific pattern
Thank you so much!! I just saved a lot of work:)
- Cornelius "JLatham" wrote: Assuming your original data is on 'Sheet1', and begins at row 1 as per your example, then on the other sheet, enter this formula in a cell on row 1: =OFFSET(Sheet1!A$1,(ROW()-1)*5,0) and fill it down the sheet. It will pick up A1, A6, A11, A16, A21, etc. from Sheet1 "Cornelius" wrote: Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform this into weekly data (starting on mon). My solution for this was to create a column with the following pattern: A1 A6 A11 And use the fill pattern to complete all 1000 observations. My problem is that Ecxel is not continuing my pattern, but starts over after 3 observations: A2 A7 A12 A3 A8 A13 and so on... I don't want it to follow this pattern, but just continue... Can anyone help me with this problem? - Cornelius |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any formula to count number of cells with a specific color pattern | Excel Worksheet Functions | |||
| Copy cells to specific sheets | Excel Worksheet Functions | |||
| Identifying A Pattern Of Values Meeting Specific Criteria | Excel Discussion (Misc queries) | |||
| How do I set the tab stops in a specific cell pattern? | Excel Worksheet Functions | |||
| How can I count cells of a specific colour (pattern)? | Excel Worksheet Functions | |||
Linear Mode
