About this tutorial:
Video duration: 5:14
Download Excel File:
See how to compare two e-mail lists where one list has extra semi-colons:
1. (00:28 min) Find and Replace feature to remove semi-colons (Ctrl + H).
2. (01:32 min) Is in List: MATCH and ISNUMBER functions.
3. (03:20 min) 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?