Comparing 2 excel files

[Guest]

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.

 

[Guest]

A small correction:
same addresses have same 7-digit number in column A
Kind regards
Michael E.

 

[Myrna Larson]

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.