E
excel0003
I like to average data by 5 rows.
example,
Column:
A1:2
A2:3
A3:4
A4:5
A5:3
A6:8
A7:9
A8:4
A9:2
A10:5
A11:6
..
AN:
I want to know the formula that calculate Averager of A1 to A5, next
from A6 to A10, next A11 to a15.......automatically. moving average
(increment by 5)
example,
Column:
A1:2
A2:3
A3:4
A4:5
A5:3
A6:8
A7:9
A8:4
A9:2
A10:5
A11:6
..
AN:
I want to know the formula that calculate Averager of A1 to A5, next
from A6 to A10, next A11 to a15.......automatically. moving average
(increment by 5)