Forum Discussion
Solved
filtre data
is there a simple solution (filter for example) to go from table 1 to 2. eliminate repetitive codes and calculate the quantity at the same time?
safwen That would be with a pivot table.
safwen Pivot table is best for this case that already shown by Riny_van_Eekelen. If you prefer formula solution then can go with- (see the attached file).
=UNIQUE(CHOOSE({1,2,3},A2:A12,B2:B12,SUMIFS(C2:C12,A2:A12,A2:A12,B2:B12,B2:B12)))