if duplicates then add quantities?
 

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?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=483478

if duplicates then add quantities?
 

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
DataConsolidate
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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483478

if duplicates then add quantities?
 

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?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=483478

if duplicates then add quantities?
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483478