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