Formula/way to compare 2 worksheets

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

Hi
I have 2 sheets(Sheet1 and Sheet2- Not very original)
Sheet 1contains about 16000 entries.Sheet 2 varies between 50 and 100
entries
I have to integrated sheet 2 into sheet 1 but must ensure there are no
duplicates BEFORE I integrate them
Any help would be appreciated.
 
Assuming the duplicates would be in column A, Sheet2 has 100 rows:

In a column on the right, put the formula

=IF(ISNA(MATCH(A1,Sheet1!$A$1:$A$16000,0)),1,0)

and copy it down through row 100.

Then use Data/AutoFilter to display only the rows with a 1 in this column. Now Edit/Copy just
the "real" data (only the visible rows will be copied) and paste to Sheet1.
 
Back
Top