Hi,
I need to find duplicate values in a column and sum its lookup value on the right column. These are the data:
DEFECT WW1
Tombstoned 9
Excess solder 8
Wrong Orien't label 7
Wrong Orien't label 10
Damage Connector 6
Damage IC's 2
Reflow 45
Bridging 26
Reflow 6
Comp Oxicide 34
Connector damage 5
Damage terminal 1
Excess solder 4
Burn tantalum 2
Damage IC's 0
Since column ("DEFECT") has duplicate values, i need to find those values and sum its corresponding ("WW1") values on the right. Those totals will be displayed in another column with its defects . Is it clear? Thanks.
Bookmarks