Hi,
I need a formula for COL C, that will put the average of the previous days values from COL B.
For example the average for 07/07/2015 in COL A, was 46 in COL B. I need to put that value in COL C., and so on down through the spreadsheet.
Thanks,
Paul
I need a formula for COL C, that will put the average of the previous days values from COL B.
For example the average for 07/07/2015 in COL A, was 46 in COL B. I need to put that value in COL C., and so on down through the spreadsheet.
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | prb^2 | Average For Day Before | ||
2 | 06/07/2015 | 25.00 | |||
3 | 07/07/2015 | 40.50 | |||
4 | 07/07/2015 | 0.00 | |||
5 | 07/07/2015 | 76.56 | |||
6 | 07/07/2015 | 66.94 | |||
7 | 08/07/2015 | 11.11 | 46.00 | ||
8 | 08/07/2015 | 69.44 | 46.00 | ||
9 | 08/07/2015 | 9.00 | 46.00 | ||
10 | 09/07/2015 | 44.44 | |||
11 | 10/07/2015 | 0.83 | |||
12 | 10/07/2015 | 11.11 | |||
13 | 10/07/2015 | 18.37 | |||
14 | 11/07/2015 | 58.48 | |||
15 | 11/07/2015 | 4.94 | |||
16 | 11/07/2015 | 56.25 | |||
17 | 11/07/2015 | 73.47 | |||
18 | 15/07/2015 | 14.06 | |||
19 | 15/07/2015 | 2.04 | |||
20 | 16/07/2015 | 11.11 | |||
21 | 16/07/2015 | 73.47 | |||
22 | 17/07/2015 | 0.00 | |||
23 | 17/07/2015 | 0.00 | |||
24 | 18/07/2015 | 25.00 | |||
25 | 18/07/2015 | 51.02 | |||
26 | 20/07/2015 | 64.00 | |||
27 | 20/07/2015 | 76.56 | |||
28 | 21/07/2015 | 21.30 | |||
29 | 21/07/2015 | 0.00 | |||
30 | 22/07/2015 | 85.21 | |||
31 | 22/07/2015 | 11.11 | |||
32 | 22/07/2015 | 25.00 | |||
33 | 22/07/2015 | 0.00 | |||
Sheet1 |
Thanks,
Paul