Good day,

I have two excel sheets, one with information in rows and each row has a name and the other sheet has the same name but with less rows and less names. Names in Sheet1 may not available in Sheet2. Meaning some names may missing in Sheet2. I would like to ask how can I delete names in Sheet1 which already appear in Sheet2. I noticed that I can use VBA however I do not know the formula or expression that can be used. Is anyone could help me? Thank you.

Assuming sheet1 column H is empty, put this in H1:

="KEY"

In H2 put this:

=ISNUMBER(MATCH(A2, Sheet2!A:A, 0))

... and copy that cell down the as far as there is data on Sheet1.

No click on H1 and turn on the Data > Filter > AutoFilter.

Use the H1 drop down to select TRUE.

Highlight and delete all the rows left visible below row1.

Now turn off the Data > Filter > AutoFilter and the unmatched names will be left.

I will try the formula. Thank you so much : )