| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
