call us today: 1.800.876.8376
email us: info@synergy.com
The following formula can be used to leave every Nth row in a column unmasked:

mask(index() mod n, c0)

As an example, mask(index() mod 10, c5) would leave rows 0, 10, 20, etc. unmasked in column 5.


Mark as helpful.
2

Posted in: Formula Entry: Advanced formulas