Solved

How to update a list in excel without replicating entries?

Posted on 2011-09-02
5
325 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
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.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now