How do I leave every Nth row in a column unmasked?

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.

Scroll to Top