Jump to content

Welcome to Geeks to Go - Register now for FREE
Geeks To Go is a helpful hub, where thousands of friendly volunteers serve up answers and support. Get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message and all ads will be removed once you have signed in.
Create an 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




Similar Topics: Excel Formula: comparing email list     x


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured