Filling data in blank cells based on the cell above and below a blank cell

[pinkpanther6666]

Good Moring to all

i need to Auto fill data into blank cells based on the cell above and below the blank cell

Cell A1 contains the value 01/01/2024
Cell A2 contains the value 01/02/2024
and filled down until Cell A365 is 31/12/2024


Cell B1 contains the value of 100
Cell B2 is blank
Cell B3 is Blank
Cell B4 contains the value 130

How can i get Cells B2 and B3 filled with the Value 110 and 120 respectively

However sometimes the Values may go down
Cells B5,B6,B7 are blank and Cell B8 is 90

See attached Image as an example


Hope anyone can help on this please

Many Thanks in Advance

Steve

 

[hagia_sofia]

The following probably is too heavy (but hopefully somebody will post something lighter):

=LET(
array,B1:B9,
a,FILTER(array,array<>""),
b,VSTACK(DROP(a,1),0),
c,IF(a<b,10,-10),
d,SCAN(0,--(ISNUMBER(array)=TRUE),LAMBDA(a,b,a+b)),
e,UNIQUE(d),
f,IF(ISNUMBER(array),0,XLOOKUP(d,e,c)),
g,SCAN(0,f,LAMBDA(x,y,IF(y=0,y,x+y))),
h,SCAN("",array,LAMBDA(a,b,IF(b<>"",b,a))),
g+h)