H2:I10{=INDEX(A:A,SMALL(IF(IFERROR(MATCH($A$2:$A$10&$B$2:$B$10&1,$A$2:$A$10&$B$2:$B$10&(MMULT(N($C$2:$F$10>0),{1;1;1;1})>0)*1,),"")=ROW($1:$9),ROW($2:$10),99),ROW(A1)))&""
J2:M10=TEXT(SUMIFS(C:C,$A:$A,$H2,$B:$B,$I2),"0;;")
O2:P11{=INDEX(H:H,SMALL(IF(MMULT(N($J$2:$M$10<>""),{1;1;1;1})>=COLUMN($A:$Z),ROW($2:$10),99),ROW(A1)))&""
Q2:Q11{=IFERROR(INDEX($1:$1,RIGHT(SMALL(IF(J$2:M$11<>"",ROW($2:$11)/1%+COLUMN(J:M)),ROW(A1)),2)),"")
R2:R11=IF(O2="","",SUMPRODUCT((H$2:H$10=O2)*(I$2:I$10=P2)*(J$1:M$1=Q2)*(0&J$2:M$10)))
留言
張貼留言