Hi,
I have 4 columns [A CODE], [B TAG],[C CUSTOMER],[D AMOUNT] this are all duplicates in the sense of columns A,B,C I want them to group. if all 3 columns matches to more of them then generate report on next sheet with consolidated 4th column of Amount, and duplicates counts occurred

Any helps.
CODE TAG CUSTOMER AMOUNT
002 101 COSMOS 74027.00
002 101 COSMOS 20718.00
002 101 COSMOS 136600.00
002 102 SAM 40000.00
002 102 SAM 80250.00
002 102 SAM 1290.00
003 120 PLUTO 5432.00
003 120 PLUTO 5674.00
003 120 PLUTO 9000.00
009 140 CLICK IT 1450.00
009 140 CLICK IT 2346.00
REPORT SHEET
CODE TAG CUSTOMER TOTAL COUNT
002 101 COSMOS 231345.00 3
002 102 SAM 121540.00 3
003 120 PLUTO 20106.00 3
009 140 CLICK IT 3796.00 2