compare 2 spreadsheets and create 3rd unique

Timehri

New Member
Joined
Mar 24, 2002
Messages
15
I was wondering how to go about the following:

I have 2 spreadsheets.
They both contain columns for part numbers, along with several other columns that are unique to each spreadsheet.
I would like to compare the two 'part number' columns and bring all the columns of data into another spreadsheet omitting any duplicate part numbers.

I would appreciate any help.

Thank you
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Is there one column of part numbers that don't repeat and one with part numbers that repeat? How much data is there? It's not that hard to write code to do such a thing but it may take a while to run if there is a large amount of data.

Dave
 
Upvote 0
MS Query is an Add-In avalable with Office Go to Tools Add-ins to activate it. If it does not appear as an add-in, you will have to re-install MS Office.
 
Upvote 0
On 2002-03-26 10:14, davers5 wrote:
Is there one column of part numbers that don't repeat and one with part numbers that repeat? How much data is there? It's not that hard to write code to do such a thing but it may take a while to run if there is a large amount of data.

Dave

Dave,
On spreadsheet 1, there are 4 columns;
part number, description, internal code and price

On spreadsheet2, there are 6 columns; part number, description and 4 others (these 4 do not match the other columns on Spreadsheet1).

The part number columns may have identical numbers, and the corresponding description columns may be different.

I would like to create a 3rd spreadsheet that incorporates all 9 columns, ommitting any duplictae part numbers.

The data is only about 500 lines each.

Thanks
 
Upvote 0
Hi
No problem
Will need:
Name of sheet1 with part numbers
Beginning Row of Data
Column PartNum
Column Description
Column Internal Code
Column Price

Name of sheet2 with part numbers
Column PartNumbers
Column Description
Col 3,4,5,6

Name of sheet3 to place combined data

You said that the part numbers may match, but the descriptions may be different?
Seeing that one of the entries will be disreguarded because of matching Part Numbers, does it matter which one?

Are they to be sorted by Part Number, Description, Internal code???

Please Reply or send the workbook to:
TsTom@hotmail.com

Tom
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top