Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Instead of deleting these rows, you can copy only rows you need.

  1. First, mark rows you don't need (or, on the contrary, only ones you need).
  2. Then filter them out (or filter only them).
    • If all repeating lines are the same, you can use =A2="preset text to filter".
    • Otherwise, you can make list of these lines and use =MATCH(A2;range_with_lines_to_filter;0).
    • And you can even create Pivot table with source lines on rows and their count on data, sorted by count, to find repeating data. And then use top of range of repeating lines in MATCH of previous bullet.
  3. Then Ctrl+A, Ctrl+V to new sheet.

Instead of deleting these rows, you can copy only rows you need.

  1. First, mark rows you don't need (or, on the contrary, only ones you need).
  2. Then filter them out (or filter only them). an unused column.
    • If all repeating lines are the same, you can use =A2="preset text to filter". to auto-mark.
    • Otherwise, you can make list of these lines and use =MATCH(A2;range_with_lines_to_filter;0).
    • And you can even create Pivot table with source lines on rows and their count on data, sorted by count, to find repeating data. And then use top lines of range of repeating lines that pivot in MATCH of previous bullet.
  3. Then Ctrl+A, Ctrl+V filter them out, Ctrl+A, Ctrl+V to new sheet.

Or vice versa, you can mark only lines you need, then filter them in.