...
Subrange notation such as [i-5:i+5] can be used to perform calculations over a range of cells.
For example:
- Fill column A with row numbers.Enter StdDev(
- Open Set Column Values dialog of col(A)[i-5:i+5]) as the formula for column B. B).
- Choose Formula: Load Sample: Moving Standard Deviations and click OK.
Then column B will be filled with the running-standard deviation over 11 points, at every row, based on the data in column A.