Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 excel files
Hallo,
I have the following problem For a mailing-campaign I use an excel file (file "A") with ca. 5000 addresses. Each row contains one address, in column A there is a special number (7 digits) for each person. A second file (file "B") contains 1000 addresses some of which are also in file "A". People in file "B" should not receive the mailing. Goal: a new file "A" where those addresses are deleted that are included in file "B". Both files have identical structures (1 address in 1 row; some addresses have same 7-digit-number in column A) Any solution for this problem? Kind regards Michael E. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 excel files
A small correction:
same addresses have same 7-digit number in column A Kind regards Michael E. "Michael E." wrote: Hallo, I have the following problem For a mailing-campaign I use an excel file (file "A") with ca. 5000 addresses. Each row contains one address, in column A there is a special number (7 digits) for each person. A second file (file "B") contains 1000 addresses some of which are also in file "A". People in file "B" should not receive the mailing. Goal: a new file "A" where those addresses are deleted that are included in file "B". Both files have identical structures (1 address in 1 row; some addresses have same 7-digit-number in column A) Any solution for this problem? Kind regards Michael E. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 excel files
Open both workbooks. In file A, in a column on the right, put this formula:
=COUNTIF([Workbook2]Sheet1!$A:$A,A2) Use AutoFilter to display rows where this value is 0, then delete those rows. On Tue, 19 Oct 2004 12:39:05 -0700, "Michael E." wrote: Hallo, I have the following problem For a mailing-campaign I use an excel file (file "A") with ca. 5000 addresses. Each row contains one address, in column A there is a special number (7 digits) for each person. A second file (file "B") contains 1000 addresses some of which are also in file "A". People in file "B" should not receive the mailing. Goal: a new file "A" where those addresses are deleted that are included in file "B". Both files have identical structures (1 address in 1 row; some addresses have same 7-digit-number in column A) Any solution for this problem? Kind regards Michael E. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two Excel Files | New Users to Excel | |||
Comparing Excel Files | Excel Discussion (Misc queries) | |||
Comparing 2 excel files | Excel Discussion (Misc queries) | |||
Comparing 2 excel files | Excel Discussion (Misc queries) | |||
Comparing a value in EXCEL and XML files | Excel Discussion (Misc queries) |