Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and 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.

Create Account How it Works

Excel Formula: comparing email list

  • Please log in to reply




  • 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


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




  • 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

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP