comparing values on different sheets and deleting
 

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

comparing values on different sheets and deleting
 

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


"np" wrote:

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