Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 349
- Office Version
- 365
- Platform
- Windows
Hi All
I have a formula in column H that seems to be incorrect. I need it to give me a moving average based on column F. I need to be able to adjust the moving average from a value set in cell A1 (could be 5 week moving average or as in this case, 8 week moving average). Obviously the first output based on 8 week moving average would show in cell H9.
Also, is it possible to change from an moving AVERAGE to a moving MEDIAN ?
Thanks
I have a formula in column H that seems to be incorrect. I need it to give me a moving average based on column F. I need to be able to adjust the moving average from a value set in cell A1 (could be 5 week moving average or as in this case, 8 week moving average). Obviously the first output based on 8 week moving average would show in cell H9.
Also, is it possible to change from an moving AVERAGE to a moving MEDIAN ?
Thanks
8 | Week | Zero | Lower | Upper | Section A | Section B | Moving AV | |
21 | 0 | 30 | 30 | 9 | 107 | #VALUE! | ||
22 | 0 | 30 | 30 | 1 | 77 | #VALUE! | ||
23 | 0 | 30 | 30 | 9 | 90 | #VALUE! | ||
24 | 0 | 30 | 30 | 8 | 36 | #VALUE! | ||
25 | 0 | 30 | 30 | 20 | 42 | #VALUE! | ||
26 | 0 | 30 | 30 | 17 | 120 | #VALUE! | ||
27 | 0 | 30 | 30 | 9 | 49 | #VALUE! | ||
28 | 0 | 30 | 30 | 5 | 14 | #VALUE! | ?? | |
29 | 0 | 30 | 30 | -16 | 55 | #VALUE! | ||
30 | 0 | 30 | 30 | 5 | 114 | #VALUE! | ||
31 | 0 | 30 | 30 | -19 | 51 | #VALUE! | ||
32 | 0 | 30 | 30 | -3 | 118 | #VALUE! | ||
33 | 0 | 30 | 30 | 4 | 53 | #VALUE! | ||
34 | 0 | 30 | 30 | -9 | 39 | #VALUE! | ||
35 | 0 | 30 | 30 | 26 | 78 | #VALUE! | ||
36 | 0 | 30 | 30 | 6 | 36 | #VALUE! | ||
37 | 0 | 30 | 30 | 3 | 82 | #VALUE! | ||
38 | 0 | 30 | 30 | -16 | 82 | #VALUE! | ||
39 | 0 | 30 | 30 | 33 | 119 | #VALUE! | ||
40 | 0 | 30 | 30 | -10 | 45 | #VALUE! | ||
41 | 0 | 30 | 30 | -5 | 103 | #VALUE! | ||
42 | 0 | 30 | 30 | -41 | 82 | #VALUE! | ||
43 | 0 | 30 | 30 | 27 | 87 | #VALUE! | ||