Foncesa
07-30-2020, 01:04 AM
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
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