彙整客戶購買商品與總額 (14884)

G2:G7{=INDEX(D:D,MIN(IF(COUNTIF(G$1:G1,D$2:D$16)=0,ROW($2:$16),99)))&""

H2:K7{=INDEX($C:$C,MIN(IF(($D$2:$D$16=$G2)*(COUNTIF($G2:G2,$C$2:$C$16)=0),ROW($2:$16),99)))&""

F2:F7=IF(G2="","",SUMPRODUCT(SUMIFS(B:B,C:C,H2:K2,D:D,G2)))