[jimmystaxwax]

Hi! I'm trying to create an Excel formula that will compare two lists of email addresses and display the non-matching email address. Does anyone know how this can be done?

thanks in advance!

[Advertisements]

You need to be clearer on what you're trying to do.

Say you have two lists of email addresses... are you comparing the first entry of list 1 against the first entry of list 2, then the second entry of list 1 with the second entry of list 2, etc. OR

are you comparing the first entry of list 1 with all the entries in list 2, then the second entry in list 1 with all the entries in list 2, etc. OR

something else?

[Vino Rosso]

You need to be clearer on what you're trying to do.

Say you have two lists of email addresses... are you comparing the first entry of list 1 against the first entry of list 2, then the second entry of list 1 with the second entry of list 2, etc. OR

are you comparing the first entry of list 1 with all the entries in list 2, then the second entry in list 1 with all the entries in list 2, etc. OR

something else?

[Jonesey]

You could use the "Match" formula which will generate an error if it doesn't find a corresponding entry on the comparison sheet

Say your comparison list is in cells B1:B100 and the cells you're testing start in A1

In cell C1, type =Match(A1,$B$1:$B$100,0) and copy this all the way down your list