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 1091-1100” Excel-Magic-Trick-1091-1100.zip – Downloaded 23 times – 194 KB