Deleting Record according to another excel file

S

Song

Hi,

I have an excel file with some names and addresses. Now I have another excel
file which contains names which should be deleted from the other file. How
can this be done? Thanks!
 
B

Bernie Deitrick

Song,

In your file with the names that need to be deleted, use a formula like

=MATCH(name,ListOfNames,False)

Like this:
=MATCH(B2,'[Delete These Names File.xls]Sheet1'!$B:$B,FALSE)

Copy it down, then sort your table based on the column with the formula, and delete any row where
the formula isn't an error.

HTH,
Bernie
MS Excel MVP
 
Top