LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Comparing 2 spreadsheets to remove duplicate names

I have 2 spreadsheets with exactly the same number of columns. They are
lists of names and addresses of donors to our organization. List 2 is a
smaller list of current donors and list 1 is a larger list of all donors from
the past. I want to send letters to all old donors who are not in list 2.
So I want to compare the 2 lists and eliminate from list 1 those donors who
are in list 2. The first column in each list is a unique Donor number. Can
I do this in Excel without having to buy a third party program? ANY help
would be GREATLY appreciated.


 
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
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
Comparing Two Spreadsheets DCSwearingen Excel Discussion (Misc queries) 4 October 17th 05 02:35 PM
comparing lists of data to remove duplicate data Tom Excel Discussion (Misc queries) 2 October 13th 05 06:16 PM
Comparing Two Spreadsheets DCSwearingen Excel Worksheet Functions 1 September 17th 05 05:36 PM
Please Help (Comparing Spreadsheets) Lostinall Excel Worksheet Functions 1 November 23rd 04 08:09 PM


All times are GMT +1. The time now is 02:19 AM.

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"