Excel Magic Trick 1108

Compare 2 Lists and Extract Records: Filter Method

TOPICS IN THIS VIDEO

  • See how to Compare Two Lists and Extract Records:
    1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1.
    2. ISNUMBER and MATCH function with Filter to extract items that are in both lists.