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

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

Hi
see your multiple other posts

--
Regards
Frank Kabel
Frankfurt, Germany

"Barry Brown" schrieb im Newsbeitrag
t...
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