Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Barry Brown
 
Posts: n/a
Default 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




  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"