| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need formula for average of rolling 4 rows in excel document
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need formula for average of rolling 4 rows in excel document
Let's say your numbers are in A1:A100
In B4 enter =AVERAGE(A1:A4) Copy this down the column Need more? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "radimum" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling average | Excel Worksheet Functions | |||
| Rolling Average | Excel Worksheet Functions | |||
| Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
| Rolling 3 mth Average | Excel Worksheet Functions | |||
| Problem with formula: need rolling average of 10 months | Excel Programming | |||
Linear Mode
