if duplicates then add quantities?

[DKY]

I have this spreadsheet and column A is the part numbers and column B is
the quantities we ordered of that part number. In some of cases we
ordered on this part number more than once leading to duplicates in the
A column. Does anyone know of a way that I can get rid of the
duplicates and add the quantities together?

 

[Ron Coderre]

If you really only have 2 columns: PartNum and Qty...you might want to
try this:

Assuming PartNum and Qty are in columns A and B, respectively, with
their data below:

D1: PartNum
E1: Qty

Select D1:E1
Data>Consolidate
Reference: Select A1:B?? (as far down as your data extends)
Click [Add]
Click 'Use labels in Top Row'
Click 'Use labels in Left Column'
Click [OK]

The result will be the consolidation you are looking for.
If you like, you could clear your original data then copy/paste the
consolidated data in its place.

Another option would be to use a pivot table.
The pivot table would let you see the totals and the count of separate
orders for each part number.

Are either of those something you could work with?

Regards,
Ron

 

[DKY]

the consolidate feature works Ron, thanks for your help. Learning
something new everyday. I'm not to educated on pivot tables though.
Are there any sites or tutorials that teach more on pivot tables?

 

[Ron Coderre]

Thanks for the feedback. I'm glad I could help.

Regarding Pivot Tables and other Excel tutorials....I like the
offerings at this location:
http://datapigtechnologies.com/ExcelMain.htm

Regards,
Ron