Formula/way to compare 2 worksheets

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.
 
M

Myrna Larson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare identifier columns from 2 sheets - remove rows that are dups 2
Need Macro to Collect Multiple Worksheet Names 3
Compare worksheets for duplicates and copy data to 1st worksheet 2
Using countif with multiple criteria 0
need formula to return data from one column after comparing 2 othe 3
Applying formula to variable number of rows 5
Copy columns and paste with blank column between 5
Have problem in Manipulating Workbook Object and make macro shortest as possible 0

Top