comparing values on different sheets and deleting

  • Thread starter Thread starter np
  • Start date Start date
N

np

Is there a way delete value on sheet2 from the values found on sheet1? For
example I have a list of items on sheet1. I need to delete all values from
sheet1 that match on sheet2. thank. np
 
You might have to do this with a few steps.

Add a column in list #1 such as:

=VLOOKUP(A2,Sheet2!$A$1:$A$5,1,FALSE)

Assuming A2 is the item you are looking for…
Assuming the names that might have dups in them is A1:A5 on Sheet2

Anything *not* found will be listed as N/A which mean Not Available.

Step 2, turn on Auto Filter. Data Filter Autofilter in 2003 or Home Tab
Sort and Filter, Filter.

Step 3 uncheck #N/A and you will be left with only duplicate items.

Step 4 Delete those rows.

Hope that helps.

Frank
 
Back
Top