Excel Magic Trick 1109

Compare 2 Lists and Extract Records: Advanced Filter Method

DESCRIPTION

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 lsist using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 66 times – 2 MB




Be the first to comment

Leave a Reply