fabiogiallo
New Member
- Joined
- Mar 1, 2018
- Messages
- 6
Good evening all,
I have a column with results with gaps (blank cells) in between and i need to calculate in another column a rolling average (non overlapping) every 6 results (as per attached image).
the blank cells could be anywhere, always changing.
Any suggestion about formula or vba code to use?
Thank you in advance.
r
I have a column with results with gaps (blank cells) in between and i need to calculate in another column a rolling average (non overlapping) every 6 results (as per attached image).
the blank cells could be anywhere, always changing.
Any suggestion about formula or vba code to use?
Thank you in advance.