Excel formula copying help
in Software ·
In Sheet2:
Code:
Then just drag it down. It’s vital that you start the formula in the first row—since it relies on the current row number to find its target—but if you have headers or some other clutter and need to start from row 2, simply swap out ROW()-1 for ROW()-2, and so on.
Code:
=AVERAGE(OFFSET(Sheet1!$A$1;INDIRECT("Sheet1!" & ADDRESS(1+6*(ROW()-1);1))-1;0;6;1))
Then just drag it down. It’s vital that you start the formula in the first row—since it relies on the current row number to find its target—but if you have headers or some other clutter and need to start from row 2, simply swap out ROW()-1 for ROW()-2, and so on.