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 community
In a new column on the first row, enter the following formula:
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,
the second, and
0 in the