Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Comparing Two Spreadsheets | Excel Discussion (Misc queries) | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
Comparing Two Spreadsheets | Excel Worksheet Functions | |||
Please Help (Comparing Spreadsheets) | Excel Worksheet Functions |