Numbers is a spreadsheet software included in the iWork productivity suite by Apple.
0
votes
1answer
1k views
Select each nth row in Numbers
I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet?
See also: Select each nth row in Excel
1
vote
1answer
202 views
Spreadsheet formula to count consecutive values in a column
I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this:
Y
Y
Y
N
Y
N
Y
Y
the desired result would be 2
Y
Y
...
