彙整每人銷費項目 (11436)

D2=IF(A2="","",IFERROR(LOOKUP(1,0/(A$1:A1=A2),D$1:D1)&",","")&B2)

(姓名不重複) H6{=INDEX(A:A,MIN(IF((COUNTIF(H$5:H5,A$2:A$99)=0)*(A$2:A$99<>""),ROW($2:$99),99)))&""

I6=LOOKUP(1,0/(A2:A99=H6),D2:D99)&""

J6=IF(H6="","",SUMIF(A:A,H6,C:C))