skipping rows for running average calculation

C

ChrisC

Hello,

I am trying to create a formula that will return the HOURLY moving average
for 5 days (or some other number of days) from a column of data that captures
every hour. So, each day has 24 data entries, one for each hour, and i need
the moving average for each hour. I anticipate that after five days at the
beginning of the data, I will have a moving average for each corresponding
hourly data entry.

Thank you. Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top