Hello everyone, and thanks in advance for all the responses...

My dilemma...

I have minute by minute data (stored in A3:A11000) and I want to turn this data into 30 minute averages so I can analyze the 370ish average data points as opposed to the entire 11000. I've done it the following way but i'm sure there must be an easier way....


Cell C3=AVERAGE(A3:A32)
Cell C4=AVERAGE(A33:A62)
Cell C5=AVERAGE(A63:A92)
etc, etc...

Can anyone help?

Regards,

Gerry