However, with a little work it’s possible to construct formula references that follow specific patterns.
The next argument isrows, which indicates the desired row offset from the starting reference.
Here, theROW functionis used to get the row number for cell D1.
We start with D1 because we want to start with 1 for the first value.
For example, if n is changed to 5, the formula will pick up every 5th value.
OFFSET is handy in formulas that require a dynamic range.
ROW Function
The Excel ROW function returns the row number for a reference.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
