How to apply a column formula on only a range of rows and not every row?
This widget could not be displayed.
Created:
Jul 15, 2022 05:52 AM
| Last Modified: Jun 10, 2023 4:51 PM(706 views)
Hi,
I am trying to create a column formula that calculates the mean of every 5 rows (for a specific column).
Normally the formula are applied to every row using values in such row. Instead, I would like to use values from 5 previous row to calculate a mean value.
I am been playing with the formula editor and try to use the Row() and other functions, but without success.