SOLVED

filtre data

Contributor

safwen_0-1663142261449.png

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?

5 Replies
best response confirmed by safwen (Contributor)
Solution

@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)))

 

Harun24HR_0-1663145654261.png

 

 

@safwen 

An alternative could be Power Query.

article code.JPG

@Riny_van_Eekelen Hi Sir i tried the same function but i didn't get the same result. can you please help me with steps ? 

safwen_0-1663161162186.png

 

@safwen You just need to change the layout of the pivot table a bit. On the Design (Creacion) tab, you'll find some layout buttons on the far left. The first two allow you to get rid of the sub- and grand totals. 

Riny_van_Eekelen_0-1663161572378.png

Then, in the Report Layout section, choose Show in Tabular Form first and then Repeat All Item Labels.

Riny_van_Eekelen_1-1663161609032.png