call us today: 1.800.876.8376
email us: info@synergy.com
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.
2

Posted in: Formula Entry: Advanced formulas