Deleting Record according to another excel file

  • Thread starter Thread starter Song
  • Start date Start date
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!
 
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
 
Back
Top