I need the a macro or cell formula to give me a rolling average of the cells. The following information is how the sheet is setup.
Average will always be on the bottom line. So one line above it is the last number needed. The first number needed will always be on line 11.
New data is inserted each day so all of the rows shift down one row but row 11 will always be the current days entry.
Tried explaining an example of how it is setup below. Please help me get this rolling average to work. I think I can use top and bottom references in a macro with an average but need your help.
Example
line 11 has 20
line 12 has 30
line 13 has 25
line 14 has 30
line 15 is average
I enter the new data today
line 11 has 33
line 12 has 20
line 13 has 30
line 14 has 25
line 15 has 30
line 16 has average
Bookmarks