Filter Every Nth Row Excel Formula
where data is the named range D5:D16. With n hardcoded into the formula as 3, FILTER function returns every 3rd row in the data. Working from the inside out, the first step is to generate a set of row numbers. This is done with the SEQUENCE function like this: The ROW function returns the count of rows in the named range data. Using the count of rows, SEQUENCE returns an array of 12 numbers in sequence: This array is returned directly to the MOD function as the number argument, with the number 3 hardcoded as the divisor....