I have the following function, which calculates the average of the previous 7 rows of the column on the left.
=AVERAGE(OFFSET(C8;-6;-1;7))
The problem: whenever I update the data column I have to update the average column in order to copy the formula.
I would like to fix this by using ARRAYFORMULA, but I do not know how to specify the current cell for OFFSET?