Tuesday, January 6, 2015

How to Compare Two Email Lists in Excel?

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?

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.

No comments:

Post a Comment