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.
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.