Comparing Data in Two Columns

[edytwinky]

I have two columns of data in Column A and B.

In column A, each cell could contain one to ten e-mail addresses.

In Column B, each cell could contain one to ten e-mail addresses that could be the same or different.

So A1 could be as@hotmail.com, as@gmail.com, as@yahoo.com
B1 could be as@hotmail.com, bb@gmail.com, bb@yahoo.com

In C1, is there any way to find what matches there are in A1 and B1?

 

[etaf]

in A1/B1 do you have all three email address or just 1 email address in any cell ?

if more than one are you trying to find another cell with the same emails
so if A1 had as@hotmail.com, as@gmail.com, as@yahoo.com
then only a match if another cell has as@hotmail.com, as@gmail.com, as@yahoo.com

OR

because as@hotmail.com
is part of both the cells you want to match on part of the text

if its a single email
then a countif() would work