LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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




 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Lists Kathy - Lovullo Links and Linking in Excel 1 December 14th 04 02:31 PM
HELP - Have two lists and #1 needs #2's contents subtracted from it Barry Brown Excel Discussion (Misc queries) 6 December 7th 04 09:49 PM
HELP - Have two lists and #1 needs #2's contents subtracted from it Barry Brown Links and Linking in Excel 1 December 7th 04 07:50 PM
Aligning Two Lists in Excel Rich Excel Discussion (Misc queries) 2 December 4th 04 05:44 PM
comapre two lists mansure Excel Discussion (Misc queries) 2 November 28th 04 01:57 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"