• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Rolling average by site

For each unique SiteID listed in column B of the attached Excel sheet, I would like to generate 7-day rolling averages of the data found in columns E, F and G.

I have manually generated the 7-day rolling averages for the first two sites (04CEF-1 and 04COK-1) in columns H, I, and J. The next set of 7-day averages should begin in row 189 (as indicated in the attached spreadsheet).

I am hoping for a solution that will automate the process of generating the 7-day rolling averages by SiteID.

Most of the SiteIDs have 92 days of data, however, this is not always the case so the solution should be able to accommodate varying data counts for each SiteID.

Many thanks in advance for any solutions!
1 Solution
barry houdiniCommented:
Try using this formula in H5 copied down and across


see attached

regards, barry
dougf1rAuthor Commented:
Works great. Many thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now