Hi everyone. I need to have a formula to achieve an average figure for a
rolling 4 rows, ie at the 5th row, discard the 1st row and re-average rows
2-5 inclusive, at the 6th row discard the 1st and 2nd rows and re-average
rows 3-6 inclusive..ad infinitum. I'm using microsoft excel.Thanks in
anticipation..Mary