Hi,
just wanted to ask, what formula could i use if for example, the difference between column B and C would be added/deducted to the next day onwards to column B.
Table below would show the progression but the output should only be 1 table
just wanted to ask, what formula could i use if for example, the difference between column B and C would be added/deducted to the next day onwards to column B.
Table below would show the progression but the output should only be 1 table
Book1 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | Data | Actual Data | Data | Actual Data | Data | Actual Data | Data | Actual Data | |||||||||
2 | 1-Aug | 100 | 1-Aug | 100 | 50 | 1-Aug | 100 | 50 | 1-Aug | 100 | 50 | ||||||
3 | 2-Aug | 100 | 2-Aug | 150 | 2-Aug | 150 | 100 | 2-Aug | 150 | 100 | |||||||
4 | 3-Aug | 100 | 3-Aug | 150 | 3-Aug | 200 | 3-Aug | 200 | 100 | ||||||||
5 | 4-Aug | 100 | 4-Aug | 150 | 4-Aug | 200 | 4-Aug | 200 | 400 | ||||||||
6 | 5-Aug | 5-Aug | 5-Aug | 5-Aug | |||||||||||||
7 | 6-Aug | 6-Aug | 6-Aug | 6-Aug | |||||||||||||
8 | 7-Aug | 200 | 7-Aug | 250 | 7-Aug | 300 | 7-Aug | 100 | |||||||||
9 | 8-Aug | 200 | 8-Aug | 250 | 8-Aug | 300 | 8-Aug | 100 | |||||||||
10 | 9-Aug | 200 | 9-Aug | 250 | 9-Aug | 300 | 9-Aug | 100 | |||||||||
11 | 10-Aug | 200 | 10-Aug | 250 | 10-Aug | 300 | 10-Aug | 100 | |||||||||
12 | 11-Aug | 200 | 11-Aug | 250 | 11-Aug | 300 | 11-Aug | 100 | |||||||||
13 | 12-Aug | 12-Aug | 12-Aug | 12-Aug | |||||||||||||
14 | 13-Aug | 13-Aug | 13-Aug | 13-Aug | |||||||||||||
15 | 14-Aug | 300 | 14-Aug | 350 | 14-Aug | 400 | 14-Aug | 200 | |||||||||
Sheet1 |