As shown in figure C 1, input = if (b1>; 100, 1,0)

Place the mouse in the lower right corner of cell C 1 When the mouse pointer changes to a black cross, double-click (automatically fill all rows in column C).

Select column c and delete it (auto-delete)

Select the row with the cell value of 1 in column C:

Select all, press the keyboard del to delete:

Continue to delete, and display rows with cell value of 0 in column C:

Select all, Ctrl+C copy. Ctrl+V paste into another worksheet or another Excel file:

The result at this time is that one line is less than 100. Delete the redundant c column: