How to Delete Duplicate Records from 2 different Tables

[jaymkent]

I have a product price file of 45,000 lines ( called complete.xls), from which we have extracted about 3,000 lines to put on to our website(called website.xls)

I now want to put the whole price file (complete.xls) on the website, but do not want to duplicate what is already on there, the table with 3000 lines (website.xls)

Is there a way to remove the 3000 lines which are on website.xls from the complete.xls file

I am unable to upload this due to the size of the file and the sensitive nature of the prices etc. So hope this is still clear

[newdoverman]

Since the website.xls was extracted from the complete.xls, I would simply delete the website.xls and upload the complete.xls to the website unless you need to have those 3000 records separate from the others for a reason not explained. If you do require the two separate files then use the procedure that you used to identify and extract the 3000 records from the complete.xls in the first place and delete them from complete.xls .

[JungleJme]

Agree with the above.


If still not suitable then assuming there is a unique identifier in Column A of both workbooks then open both files and in the last column of complete.xls type a header, then in row 2 type:

=MATCH(A2,[website.xls]Sheet1!$A:$A,0)

If the row item is in the Website .xls file. The formula will return a number.

If the row item is NOT in the Website file then the formula will return a #N/A

Simply filter on and delete anything with a number from the Complete.xls and upload.