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
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI 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
In a new column on the first row, enter the following formula:
=MOD(ROW(), 5)
Copy that cell to every row in the column. It should output the remainder of each row number divided by 5 [1,2,3,4,0,1,2,3,4,0,1…].
Click the Sort & Filter button (or select Table › Show Sort & Filter Panel from the menu).
In the Sort & Filter Panel, check
the box next to "Show Rows that
Match the Following." Then select
the new column that contains the
formula in the first dropdown, is
in
the second, and 0
in the
textbox.