C4{=IF(I3+J3=4,LEFT(LOOKUP(1,-(MMULT(IFERROR(1/(FIND(TRANSPOSE(IF(COUNTIF(B3:D3,LEFT(G2:G14)),RIGHT(G2:G14))),G2:G14)=1),),ROW(2:14)^0)>0)*COUNTIF(B5:D5,RIGHT(G2:G14)),G2:G14)),"找不到")
I3{=SUM((MMULT(IFERROR(1/(FIND(TRANSPOSE(IF(COUNTIF(B3:D3,LEFT(G2:G14)),RIGHT(G2:G14))),G2:G14)=1),),ROW(2:14)^0)>0)*COUNTIF(B5:D5,RIGHT(G2:G14)))
J3{=SUM((MMULT(IFERROR(1/(FIND(TRANSPOSE(IF(COUNTIF(B5:D5,RIGHT(G2:G14)),LEFT(G2:G14))),G2:G14)=2),),ROW(2:14)^0)>0)*COUNTIF(B3:D3,LEFT(G2:G14)))
留言
張貼留言