同品名 級數 聚單元格 (14233)

D2:D13=IFERROR(LOOKUP(1,0/(A$1:A1=A2)/(C$1:C1=C2)/(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)=1),D$1:D1)&"  ","")&B2

G2:I4=IFERROR(LOOKUP(1,0/($A$2:$A$13=$F2)/($C$2:$C$13=G$1),$D$2:$D$13),"")



留言