how to merge two spreadsheets and remove duplicated entries.

L

Lamb Chop

I have two spreadsheets

They are in the same format, ie.

A:A contain serial number
B:B contain product names
C:C supplier
D:D address
....
....


The two spreadsheets are regularly update by me and my bussiness partner in
another country.

However, when I get the file from my partner, her spreadsheet may contain
some new entries.
If I just copy and paste her spread sheet into mine and there will be some
items being double entry.

How can I delete the double entries after copy and paste?

Thanks
 
G

Guest

Add a new column at the end. Assuming the data starts in row 2, type in the
first row
=COUNTIF($A$2:$A2,$A2)

and drag the formula down

Autofilter the results for numbers greater than 1.

HTH
Danny
 

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

How can I compare spreadsheets and remove duplicated data? 3
How do I match and append/merge data from two spreadsheets? 2
comparing columns in two spreadsheets 1
How do I combine two spreadsheets and delete the duplicated info 1
Merging data from several Excel 2010 spreadhseets 5
How do I merge duplicated data in rows with different criteria 1
How to use Copy and Paste 2
Compare and import data using two spreadsheets 1

Top