Excel Advanced Filter Items in a List

Excel Advanced Filter Items in a List

Use an Excel Advanced Filter to copy specific items from a list, to a new location.

Set up an advanced filter criteria range, with a blank heading cell, or a heading that is different than any heading in the original table.
Then, use a criteria formula to find cells that exist in a separate list. In this video, the item list is in column I.

The criteria formula, if the first data is in cell C2 is: =COUNTIF(I:I,C2)
If the result of that formula is 0, the record is not in the list, and won’t be filtered to the other sheet.

See the steps in this short Excel video tutorial.

Nguồn: https://issep2014.org

Xem thêm bài viết khác: https://issep2014.org/cong-nghe

Tagged In: