K2:O8{=OFFSET($A$1,SMALL(IF(MATCH($A$2:$A$16&$D$2:$D$16,$A$2:$A$16&$D$2:$D$16,)=ROW($1:$15),ROW($1:$15),99),ROW(A1)),COLUMN(A1)*3-3)&""
另解K2:O8{=OFFSET($A$1,SMALL(IF(COUNTIFS($K$1:$K1,$A$2:$A$16,$L$1:$L1,$D$2:$D$16)=0,ROW($1:$15),99),1),COLUMN(A1)*3-3)&""
M2:M8=IF(K2="","",SUMIFS(F:F,A:A,K2,D:D,L2))
N2:O8=IF($K2="","",SUMIFS(H:H,$A:$A,$K2,$D:$D,$L2))
留言
張貼留言