call us today: 1.800.876.8376
email us:
If you want to take every Xth row from an input column and store it in a separate column, use the following series of formulas:

mask(index() mod n, input);cell(index()/n, output) = input;unmask(1, input); where n is the row number to keep, input is the input column number (e.g. c0, c1, etc.) and output is the output column number (e.g. 1, 2, etc.).

Mark as helpful.

Posted in: Formula Entry: Advanced formulas