Mar 3, 2015
how to I script a recursive function to a sum column that uses itself and a neighboring column. I attached an example... Col 2 in this example would be the one that needs a recursive-type formula. Thank you for your help. Christa
Mar 21, 2013
You can get close, like this. The if statement in the formula deals with the lag(formulaCol) getting started without a cascade of missing values.