I am stuck on how to get a 4 month moving average for up to 200 facilites. Attached is an example of what type of data I am looking at. I need to know the best way to go about getting this type of average.
I am stuck on how to get a 4 month moving average for up to 200 facilites. Attached is an example of what type of data I am looking at. I need to know the best way to go about getting this type of average.
see if the attached is what you want? I added a helper column so I could use the 1st day of the month (always 1) instead of the last day of the month (could be 28, 30 or 31)
If you change the value in E2, you van vary the rolling months
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Is there a way to get it by facility instead of all
Is there away to do a match and index to get the moving average?
Pl see attached file.
This looks like it is it, Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks