PDA

View Full Version : [SOLVED] 3 columns matched create report



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

p45cal
07-30-2020, 01:55 AM
In the attached, two solutions:
1. A basic pivot table
2. A power query solution.