Replace Zeros with the most recent value.

[mescalante48]

Hello everyone,

Please see the example below.
what would be the formula in C1 so to return the most recent non Zero value of column B until a new value appears.

the input is column B, the goal is column C

No arrays and no VBA, since this is for Sierra Chart.

Any comment will help.

Gyazo

 

[jasonb75]

In C1 and fill down

=IF(B1=0,C2,B1)

 

[mescalante48]

In C1 and fill down

=IF(B1=0,C2,B1)

Thank you!

 

[mescalante48]

In C1 and fill down

=IF(B1=0,C2,B1)

you are correct, but please see below, what if we need it like this instead?
coping the value down till the next non zero value

Gyazo

 

[jasonb75]

For that you will need to insert an empty row above, the data must start in row 2 with row 1 being empty.
In B2 and fill down

=IF(A2=0,B1,A2)