How do I remove duplicates and then merge two excel files?
February 7, 2007 6:25 PM Subscribe
In MS Excel, how do I remove duplicates, clean up a document and merge two files together?
posted by perpetualstroll to computers & internet (6 answers total) 10 users marked this as a favorite
I have found a few threads in Google, but none of them have quite what I'm looking for, I'm hoping someone will have experience doing this. Right now, I have to do this manually, but I figure there has to be a more efficient way of completing this.
This is a bit complicated, but I'll try to simplify as best as I can:
I have two excel files, A and B.
File A contains the fields PART NUMBER and PRICE and is laid out as follows:
a1000 total $2.50
a1001 total $3.25
a1002 total $6.62
1) How do I remove all the duplicate records?
2) How do I remove all the rows that contain the word "total" in the PART NUMBER field?
File B contains a master list of a lot more information for other parts and the formatting needs to be retained. After cleaning up File A, is there a import those values to a designated column for their corresponding part numbers in File B?
Any help would be MUCH appreciated.