Spreadsheet: 754657d1636410314-how-do-i-fill-the-cells-between-2-numbers-with-a-linear-series-of-values-bo_ry_fillwithlinearseries-i-
Sheet: Sheet1

entry-d | exit-d | lng-entry-$ | shrt-entry-$ | lng-exit-$ | shrt-exit-$ | longs | shorts
2021-11-05 00:00:00 | 2021-11-05 00:00:00 |  | 304.0435654779216 | 304.0435654779216 |  | 304.0435654779216 | 304.0435654779216 |  | columns g & h - how do I fill the cells between 2 numbers with a linear series of values - not knowing where the next non-empty cell might be?
 |  |  |  |  |  |  | 301.8930709573207
 |  |  |  |  |  |  | 299.7425764367198
 |  |  |  |  |  |  | 297.592081916119
 |  |  |  |  |  |  | 295.4415873955181
 |  |  |  |  |  |  | 293.2910928749172
 |  |  |  |  |  |  | 291.1405983543163 |  | most of my problems were due to not entering the formula as an array one, but...
 |  |  |  |  |  |  | 288.9901038337154
 |  |  |  |  |  |  | 286.8396093131145 |  | I fail to amend the formula with an if( -statement
 |  |  |  |  |  |  | 284.6891147925136 |  | further, it fails in the master spreadsheet where this came from, because the values do come from a formula
 |  |  |  |  |  |  | 282.5386202719127 |  | tried to replace the isformula with isnumber() or not(isblank()), but get circular
 |  |  |  |  |  |  | 280.3881257513119
 |  |  |  |  |  |  | 278.237631230711
 |  |  |  |  |  |  | 276.0871367101101
 |  |  |  |  |  |  | 273.9366421895092
 |  |  |  |  |  |  | 271.7861476689083
 |  |  |  |  |  |  | 269.6356531483074
 |  |  |  |  |  |  | 267.4851586277065
 |  |  |  |  |  |  | 265.3346641071057
 |  |  |  |  |  |  | 263.1841695865048
 |  |  |  |  |  |  | 261.0336750659039
 |  |  |  |  |  |  | 258.883180545303
 |  |  |  |  |  |  | 256.7326860247021
 |  |  |  |  |  |  | 254.5821915041012
 |  |  |  |  |  |  | 252.4316969835003
 |  |  |  |  |  |  | 250.2812024628994
 |  |  |  |  |  |  | 248.1307079422986
 |  |  |  |  |  |  | 245.9802134216977
 |  |  |  |  |  |  | 243.8297189010968
 |  |  |  |  |  |  | 241.6792243804959
 |  |  |  |  |  |  | 239.528729859895
 |  |  |  |  |  |  | 237.3782353392941
 |  |  |  |  |  |  | 235.2277408186932
 |  |  |  |  |  |  | 233.0772462980923
 |  |  |  |  |  |  | 230.9267517774915
 |  |  |  |  |  |  | 228.7762572568906
2021-09-15 00:00:00 |  | 219.9969647836373 |  |  |  | 219.9969647836373 | 226.6257627362897
 |  |  |  |  |  |  | 224.4752682156888
 | 2021-09-13 00:00:00 |  |  |  | 222.3247736950884 |  | 222.3247736950884
2021-09-10 00:00:00 | 2021-09-10 00:00:00 |  | 226.2599963626679 | 226.2599963626679 |  | 226.2599963626679 | 226.2599963626679
2021-07-19 00:00:00 |  | 179.7140342990358 |  |  |  | 179.7140342990358
 |  |  |  |  |  |  |  |  | these (cells g82-g85) should not contain values, no lng-pos - e.g. the series should only be between lng entry/exit
 | 2021-07-13 00:00:00 |  |  |  | 202.8934874427218 |  | 202.8934874427218
2021-07-12 00:00:00 | 2021-07-12 00:00:00 |  | 204.5185501684647 | 204.5185501684647 |  | 204.5185501684647 | 204.5185501684647
2021-06-21 00:00:00 | 2021-06-21 00:00:00 | 184.4288337044324 |  |  | 184.4288337044324 | 184.4288337044324 | 184.4288337044324
 |  |  |  |  |  |  |  |  | didn't travel 1st because I did not enter it as array-formula
2021-06-17 00:00:00 | 2021-06-17 00:00:00 |  | 181.6752380948743 | 181.6752380948743 |  | 181.6752380948743 | 181.6752380948743
2021-05-27 00:00:00 | 2021-05-27 00:00:00 | 155.4002674908716 |  |  | 155.4002674908716 | 155.4002674908716 | 155.4002674908716
2021-05-20 00:00:00 | 2021-05-20 00:00:00 |  | 144.1910953900825 | 144.1910953900825 |  | 144.1910953900825 | 144.1910953900825
2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 141.0388701388687 |  |  | 141.0388701388687 | 141.0388701388687 | 141.0388701388687
2021-05-14 00:00:00 | 2021-05-14 00:00:00 |  | 139.3656288187782 | 139.3656288187782 |  | 139.3656288187782 | 139.3656288187782
 |  |  |  |  |  |  |  |  | why is this #N/A?, assume because the time interval to the earlier date is longer - how to adjust the formula?
2020-12-15 00:00:00 |  | 131.7868160755591 |  |  |  | 131.7868160755591
 |  |  |  |  |  |  |  |  | where do these values come from?
entry-d | exit-d | lng-entry-$ | shrt-entry-$ | lng-exit-$ | shrt-exit-$