Hi all is it possible to get some help please with matching email addresses from one column to another please?
Column A contains email addresses as entered by several users. Column B contains email addresses that need to be excluded.
BUT, sometimes column A isn't always entered in the correct format so doesn't match anything in column B when doing an exact match so I need a way to match it based on a similar string contained in both columns. Just the formula to use will help.
I've attached an example list here:
User entered emails (sample)
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
Emails to exclude (sample)
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
Thanks in advance.
Bookmarks