Hi,

I have a large dataset of 86,400 rows of data for 12 hours in seconds and need to convert to 1 minute average data.

The data starts in K2 and need to average every 59 rows to compile into minutes. Hence, first K2:K60, second set of data K61:K120, third set of data K121:K180.

Could you advise what is the correct Average Offset function to use?

I have tried the a few functions which are providing incorrect results.

Thanks