Excel Magic Trick 1098

Compare Two E-mail Lists with Formula: E-mail In List? Not In List?

TOPICS IN THIS VIDEO

  • See how to compare two e-mail lists where one list has extra semi-colons:

    (00:28) Find and Replace feature to remove semi-colons (Ctrl + H).
    (01:32) Is in List: MATCH and ISNUMBER functions.
    (03:20) Is NOT in List: MATCH and ISNA functions.

    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?