Desperately Need assistance!! Splitting data into intervals

[Johno203]

Hey there!

So I have some daily stock returns over about 8 trading years and need to split them up into 60 day intervals....how do I do this?

THANKS FOR HELPING

 

[Johno203]

Hey there!

So I have some daily stock returns over about 8 trading years and need to split them up into 60 day intervals....how do I do this?

THANKS FOR HELPING

Actually i need to split them into 60 equal intervals...not 60 day intervals

 

[tusharm]

Figure out how many rows of data (daily stock returns) you have.

In an adjacent column starting with the same row as your data, enter the numbers 1 and 2. Move the cursor over the right-bottom cell containing the 2 and double-click. Each row should now be sequentially numbered.

Divide the total number of rows by 6. Say this result is N. Identify the rows containing N, N*2, N*3, etc. in the column added above. These are the markers for the desired ranges.

 

[dave3009]

I tried this and it seemed to do the trick

=INT((ROW()-1)/(MATCH("*",A:A,-1 )/60))+1

Copied down, now the first section of the 60 will be marked with a 1 and each will be equal size (allowing for some discrepancy of +/-1 record in each segment as it may be possible that your total records are not exactly divisible by 60)