Lag formula not working when scripted
I have some experimental data that takes a measurement every minute for 10 minutes.I then want to take an average for a subset of data points in the middle of the set.My solution is to have a hidden column (:Range) with a formula that contains the criteria (input via a modal window) and sets each row as either 1 or 0 if it's to be included in the calculation.My output column then uses the Col Mean...