Compare identifier columns from 2 sheets - remove rows that are dups
I have two sheets with thousands of rows. I need to remove rows from the 2nd
sheet that have the same identifier as rows in the first sheet... so there are
no duplicates.
Example...
'Sheet1'
ddd1234 <several data columns
ddd1234 <several data columns
abc1234 <several data columns
wrd1234 <several data columns
wrd1234 <several data columns
'Sheet2'
ddd1234 <several data columns
abc1234 <several data columns
wrd1234 <several data columns
www1234 <several data columns
ggg1234 <several data columns
.... yes, Sheet1 may have multiple rows with the same identifier but that does
not matter... I just want to remove rows from Sheet2 anything that matches IDs
from Sheet1 - I don't care about consolidating or removing dups from Sheet1.
thx for the help!
|