See how to Compare Two Lists and Extract Records with Excel Advanced Filter:
1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area with ISNA and MATCH functions.
2. Extract items that are in both list using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.
1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area with ISNA and MATCH functions.
2. Extract items that are in both list using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.
