Formula to use previous value if not missing, otherwise use value from last occupied cell
I'm trying to write a formula in Col3 that adds the current value of Col1 with the lagged value of Col2 but I'm running into a pickle trying to figure out how to carry forward the last observation from Col2 when missing data is encountered and to use this value at the first instance of non-missing data. That is,
If( !IsMissing( Col1)
Col1 + Lag(Col2,1);
//create variable that contai...
DaveLee