| 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 |
| 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 | |||
Threaded Mode
