HELP - Have two lists and #1 needs #2's contents subtracted from it

[Barry Brown]

If anybody can help with this problem in Excel 2003 I will SURELY appreciate
it!

I have a list of 10,000 names in list #1. Each piece of information is
broken down into its own column (First Name, Last Name, Company Name,
Company Address, etc.) as it was exported out of Maximizer Enterprise in
Lotus Notes. I imported this information into Excel.

List #2 is a list of 5000 of the same names, but these names are those of
list 1 that do NOT have email addresses. These are the people we postal mail
information to.

What I have to have is list #2 subtracted completely from list #1, which
will leave the number of people that we email announcements to and do not
postal mail to.

How do I do that in Excel 2003? It sounds easy enough, but I'm having a heck
of a time getting it done.

Thanks in advance for any help you can give me!

Barry

Jeremiah 29:11

 

[Frank Kabel]

Hi
start with:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
and then use a filter for deleting the rows

 

[Barry Brown]

I've worked with computers for 10 years, but I haven't worked in Excel very
much at all. I'm more a graphic designer and network administrator, so sorry
for the dumb questions...

....but I have two separate files. This information seems that it is working
within the same document but in two categories. Am I reading something
entirely wrong?

 

[Barry Brown]

....I'm trying to paste the information into the same worksheet, but one has
less information in it than the other, and there are several ranges of
information. I'm just a little confused. Thanks for any help you can give
me.

 

[Dave Peterson]

When you use this formula:

=IF(COUNTIF($A$1:$A$10,B1)=0,B1,"")

You can actually point at the other workbook.

Instead of typing in the formula, let excel do the work for you.

Open both files.

Start typing your formula in the cell you want:
=if(countif(
But now use window on the menubar to go to the other workbook and the other
worksheet and point at the column you want to examine. You should see something
like:

=if(countif([book2.xls]Sheet1!$B:$B

Type a comma and complete the formula:

=if(countif([book2.xls]Sheet1!$A:$A,B1)=0,b1,"")

And hit enter and copy it down.


If you used a different formula, the same type of technique will still apply.