Add numbers for duplicate entries then delete
 

Hi,

I have 3 cells A = part number, B = Discription, C = times ordered

Col A has duplicate entries
Col B has variences for discription (i.e. screw and wood screw both are
the same part number)
Col C times ordered (screw 32 and wood screw 14)
I want to add the duplicate part number totals and display them one
time without the discription.
Befo
A..................B
1234............2
1234............3
1235............1

After:
A..............B
1234........5
1235........1

Any help is greatly appreciated.


--
Chillygoose
------------------------------------------------------------------------
Chillygoose's Profile: http://www.excelforum.com/member.php...o&userid=10563
View this thread: http://www.excelforum.com/showthread...hreadid=274512

Hi
I would create a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Chillygoose" schrieb im
Newsbeitrag ...

Hi,

I have 3 cells A = part number, B = Discription, C = times ordered

Col A has duplicate entries
Col B has variences for discription (i.e. screw and wood screw both
are
the same part number)
Col C times ordered (screw 32 and wood screw 14)
I want to add the duplicate part number totals and display them one
time without the discription.
Befo
A..................B
1234............2
1234............3
1235............1

After:
A..............B
1234........5
1235........1

Any help is greatly appreciated.


--
Chillygoose
---------------------------------------------------------------------
---
Chillygoose's Profile:
http://www.excelforum.com/member.php...o&userid=10563
View this thread:
http://www.excelforum.com/showthread...hreadid=274512