K5:K13{=INDEX(A:A,SMALL(IF(COUNTIF(K$4:K4,IF({1,0},A$5:A$9,A$14:A$18))=0,IF({1,0},ROW($5:$9),ROW($14:$18)),99),1))&""
M3:V3{=IFERROR(SMALL(IF((COUNTIF($L3:L3,IF({1;0},$C3:$I3,$C12:$I12))=0)*(IF({1;0},$C3:$I3,$C12:$I12)),IF({1;0},$C3:$I3,$C12:$I12)),1),"")
M4:V4=IF(M3="","",IFERROR(HLOOKUP(M$3,$C3:$I4,2,),HLOOKUP(M$3,$C12:$I13,2,)))
M5:V13=SUMPRODUCT(($A$5:$A$9=$K5)*($C$3:$I$3=M$3)*$C$5:$I$9+($A$14:$A$18=$K5)*($C$12:$I$12=M$3)*$C$14:$I$18)
留言
張貼留言