• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

How to update a list in excel without replicating entries?

I have an excel sheet with a huge list of part numbers and corresponding colums of information. What i need to do is copy a different list of part numbers which i can arrange into the same format as for columns and then i have to merge them without having replicating part numbers??? is there anyway of doing this quicky and effort less theres like 10 diffrent files i have to merge into one! Please help :)
0
Osram34
Asked:
Osram34
  • 2
  • 2
2 Solutions
 
TommySzalapskiCommented:
If you are on Excel 2007/2010 then just merge them all and use Data->'Remove Duplicates' from the menu.
0
 
BusyMamaCommented:
I would do this in an Access database.

Create one table that has all of the columns in the same order as the spreadsheets.
Make the part number the primary key.
Copy and paste each of the spreadsheets into the table.  If there is a duplicate part number, Access will refuse to paste the duplicate record into the table (will give you an "error message" about duplicating primary keys, and create a "Paste Errors" table so you can see what didn't go into the table if you want).

Once you have them all in the Access table, you can always copy them back into Excel if you want.
0
 
BusyMamaCommented:
*If you don't have 2007 or 2010.  :)
0
 
TommySzalapskiCommented:
If you don't have Excel 2007/2010 you can do it with the advanced filter option. Since the number of people using 2003 is declining, I was going to wait to mention that if needed.

Before moving everything into Access, try this (if you have 2003 or before):
http://www.lytebyte.com/2008/10/30/how-to-remove-duplicates-in-excel-2003/
0
 
Osram34Author Commented:
Both are good answeres might do it the excel quick way and eventually start my own database so when i get this request from my clients i will just just database. Thanks
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now