selecting 1 in every 5 cells in a column.

[PMcGovern]

Hi everyone happy new year.
May problem is that I have gathered a lot of data from a logger takin
a sample every second for 10 hours. From this data I would like to mak
list consisting of data for every 5 seconds, 30 second ,1 minute etc
As I have 36,000 samples I do not want to do this by hand. I'm sur
there must be a way of doing this in excel. Does anyone know how to d
this. Any help would be most appreciated. Thank you

 

[JE McGimpsey]

One way:

Assume data on Sheet1 and list on sheet2.

5 seconds:
A1: =INDEX(Sheet1!A:A,ROW()*5-4)

30 seconds:
A1: =INDEX(Sheet1!A:A,ROW()*30-29)

1 minute:
A1: =INDEX(Sheet1!A:A,ROW()*60-59)

etc.

copy down as far as necessary