FalconFlyer
New Member
- Joined
- May 18, 2015
- Messages
- 30
I am trying to calculate a rolling 12 month average. The hard part is I need to keep a column ("Total" column).
I am not sure the easiest way around this. I'm assuming OFFSET can be used, but am looking for ideas.
TIA
<tbody>
</tbody>
I am not sure the easiest way around this. I'm assuming OFFSET can be used, but am looking for ideas.
TIA
May 2017 | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Jan 2018 | Feb | Mar | Apr |
1 | 2 | 2 | 3 | 5 | 10 | 12 | 10 | 45 | 1 | 5 | 5 | 2 |
<tbody>
</tbody>