Hi,

I have a data set with 1 second intervals running up 180 seconds. I would like to be able to break this down into 15 second averages i.e. from 1 to 15, 16 to 30 etc. Please can someone show me an easy way to do this so I do not have to manually input the formula.

I have included a spreadsheet as an example.

Many thanks,

Andy

Data Averaging Spreadsheet.xlsx