ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi,
I wonder if anyone might be able to help, please. I have the below worksheet and need to come up with a formula to populate the yellow highlighted column (AD).
Basically, I want to have a running average for each individual week’s-worth of runs. i.e. When each week ends, I want the average for just that week to appear in all rows for that particular week. I have identified the unique weeks in column Z, so you can identify when the current week ends and the next begins.
The file example is available here: Weekly Average Times.xlsx
Thanks in advance,
Olly.
I wonder if anyone might be able to help, please. I have the below worksheet and need to come up with a formula to populate the yellow highlighted column (AD).
Basically, I want to have a running average for each individual week’s-worth of runs. i.e. When each week ends, I want the average for just that week to appear in all rows for that particular week. I have identified the unique weeks in column Z, so you can identify when the current week ends and the next begins.
The file example is available here: Weekly Average Times.xlsx
Thanks in advance,
Olly.
Last edited: