https://webapps.stackexchange.com/questions/134541/is-it-possible-to-automatically-fill-in-missing-data-in-between-filled-data-po/134557#134557
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
date
weight entered
With =Trend()with Forecast
with Arrayformula + Forecast
2
September 1 2019126126126.0
3
September 2 2019125.5125.8125.8
4
September 3 2019125125.5125.5
5
September 4 2019124.5125.1125.1
6
September 5 2019125124125.0124.8
7
September 6 2019123.8124.4124.4entered data
8
September 7 2019123.6124.1124.1trend data
9
September 8 2019123.4123.8123.8
10
September 9 2019123.2123.4123.4=Trend()
11
September 10 2019123123123.0123.1=Forecast()
12
September 11 2019122.4122.8122.8
=Arrayformula + forecast()
13
September 12 2019122.0727273122.4122.4
14
September 13 2019121.7454545122.1122.1
15
September 14 2019121.4181818121.8121.8
16
September 15 2019121.0909091121.4121.4
17
September 16 2019120.7636364121.1121.1
18
September 17 2019120.4363636120.7120.7
19
September 18 2019120.1090909120.4120.4
20
September 19 2019119.7818182120.1120.1
21
September 20 2019119.4545455119.7119.7
22
September 21 2019119.1272727119.4119.4
23
September 22 2019118.8119.1119.1
24
September 23 2019118.4727273118.7118.7
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...