• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Culling a emailing list in Excell 2003


I have a emailing list (List A) in Excel 2003 that has a number of addresses that Bounce.

I also have another list (List B) that contains all the addresses that have bounced.

How can I remove the addressed in List B from List A using Excel 2003.

Or is there a better program for this?

Thanks in advance,
Tom Fullen
Tom Fullen
Tom Fullen
  • 2
1 Solution
If Sheet1 contains List A. Like this.
 List Aand Sheet2 contains List B. Like this.
List B
Then, Add this to Sheet1
New Sheet1and add these formulas to Sheet2
New Sheet2
You should get this result:
Result (Sheet2)
Then just filter, and delete ones that say Remove.
Tom FullenAuthor Commented:
Thank you, gnazareth,

How do you add the formula to all the cells in the column so that the A2, A3, A4, are added automatically, and I won't have to type into every cell?

Tom FullenAuthor Commented:
The formula  is not excepted seems to be something wrong with the table array?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now