Jump to content


Create Account Login to Account

Excel Formula: comparing email list


  • Please log in to reply

#1
jimmystaxwax

jimmystaxwax

    Member

  • Member
  • PipPip
  • 11 posts
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!
  • 0

Advertisement


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
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?
  • 0

#3
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
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
  • 0

Advertisement





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured
Malware Removal How to Guides Windows 7 System Building Download Files Register welcome

Never used a forum? Learn how.