Calling all Excel gurus!
I have a column of numbers which I wish to calculate an ongoing a moving average for.
Which formula do I need to use to calculate it?
The AVERAGE only seems to calculate for the whole column, I want to be able to have an average in each cell as the worksheet fills up.
Wideboy
I have a column of numbers which I wish to calculate an ongoing a moving average for.
Which formula do I need to use to calculate it?
The AVERAGE only seems to calculate for the whole column, I want to be able to have an average in each cell as the worksheet fills up.
Wideboy