Excel Magic Trick 1098

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

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 54 times – 2 MB




Be the first to comment

Leave a Reply