Solved

How to update a list in excel without replicating entries?

Posted on 2011-09-02
5
353 Views
Last Modified: 2012-05-12
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
Comment
Question by:Osram34
  • 2
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 225 total points
ID: 36474633
If you are on Excel 2007/2010 then just merge them all and use Data->'Remove Duplicates' from the menu.
0
 
LVL 7

Assisted Solution

by:BusyMama
BusyMama earned 25 total points
ID: 36474640
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
 
LVL 7

Expert Comment

by:BusyMama
ID: 36474654
*If you don't have 2007 or 2010.  :)
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 36474678
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
 

Author Closing Comment

by:Osram34
ID: 36474700
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question