Need some expert help, please. As you can see below, the formula in cell c13 is an array that calculates a 12-day moving average for that data in column B. You can also see that column B has non-numeric data, which is why I'm using the array in C.
Here's my problem. I want the formula in column C to be part of the table so that it (and its associated charts on other tabs) auto-update when I add the next day's worth of data.
Any ideas? (Right now, the formula in C13 is just copied down, the table isn't automatically filling in that formula for me, presumably because I didn't create the formula in C2 (because it's a 12-day moving average).
Happy to clarify more...and thank you in advance for your help.
Unknown
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Here's my problem. I want the formula in column C to be part of the table so that it (and its associated charts on other tabs) auto-update when I add the next day's worth of data.
Any ideas? (Right now, the formula in C13 is just copied down, the table isn't automatically filling in that formula for me, presumably because I didn't create the formula in C2 (because it's a 12-day moving average).
Happy to clarify more...and thank you in advance for your help.
Unknown
A | B | C | |
---|---|---|---|
1 | Date2 | ARI | ARI2 |
2 | 42099 | #DIV/0! | |
3 | 42100 | 6.91 | |
4 | 42101 | 14.86 | |
5 | 42102 | 4.24 | |
6 | 42103 | #DIV/0! | |
7 | 42104 | 7.45 | |
8 | 42105 | 10.65 | |
9 | 42106 | 6.24 | |
10 | 42107 | 14.86 | |
11 | 42108 | 3.84 | |
12 | 42109 | 7.68 | |
13 | 42110 | 15.99 | 9.27 |
14 | 42111 | 17.14 | 9.99 |
15 | 42112 | 5.34 | 9.84 |
16 | 42113 | 10.19 | 9.42 |
17 | 42114 | #DIV/0! | 9.94 |
18 | 42115 | 3.84 | 9.38 |
19 | 42116 | 12.95 | 9.88 |
20 | 42117 | #DIV/0! | 9.81 |
<tbody>
</tbody>
Sheet2
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>
Array Formulas
<tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>