Combine Excel's Mod() function and a simple filter to delete unwanted rows.
- Select the column with the Mod() functions. In this case, that's G1:G11.
- Choose Filter from the Data menu.
- Select AutoFilter.
- Using the filter drop-down arrow, choose 0. Excel will display only the rows that contain a 0 in column G.
- Select the rows displayed by the filter; in this case, that's rows 4, 7, and 10.
- Choose Delete Row from the Edit menu to delete the selected rows.
- Remove the filter by selecting (All) from its drop-down list.
- Uncheck AutoFilter from the Filter menu (the Data menu).
- Delete the sequential number list in column F and the Mod() functions in column G. (Or leave them, if you need to repeat this task frequently.)