0

Filter by Cell Value is smart enough to identify and delete all rows containing a match to a list in another column. BUT I want to capture and keep them! (instead of deleting). If excel can identify them and delete them, it should also be able to identify and copy them to a clipboard. How do I make it do that?

1 Answer 1

0

If you are using AutoFilter, just erase all item's check boxes, and check only what you want.

Excel's filter doesn't delete rows - just hide it.

1
  • I'm seeking to match values in column 1 of a multicolumn dataset, with values from a separate list. If column 1 contains a match, copy that row (or alternatlively show that row and delete all the others).
    – user611028
    Jun 29, 2016 at 12:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .