Jump to content

Free help from tech experts
Welcome to Geeks to Go forums. Create an account now to gain access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing topics, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. Best of all, registration and all assistance is 100% free! This message, and all ads will be removed once you have signed in.
Sign In Create 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

Similar Topics: Excel Formula: comparing email list     x


#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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured