Excel Magic Trick 1099

Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

TOPICS IN THIS VIDEO

  • See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps.
    (00:08) Setup of problem
    (00:46) Excel Table Feature to create dynamic range.
    (01:42) Is in List: MATCH, ISNUMBER and SUBSTITUTE functions, Table Formula Nomenclature (Structured Table References), non-array formula.
    (03:37) Is in List: MATCH, ISNUMBER and SUBSTITUTE functions, Table Formula Nomenclature (Structured Table References), Yes: ARRAY FORMULA.
    (05:59) Test the new data dump: Contract and Expand Excel Table using Mouse.

    Compare Two Email Lists.
    Is Email in List?
    Is email NOT in List?

    Compare 2 E-mail Lists.
    Is E-mail in List?
    Is e-mail NOT in List?

    Compare 2 Lists with semi-colon discrepancies