Excel Magic Trick 1108

Compare 2 Lists and Extract Records: Filter Method

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply