E2=IF(AND(IFERROR(MMULT(FIND(A2:C2,PHONETIC(OFFSET(A2:C2,ROW(1:9),))),{1;1;1}),)=6),"OK","NO")
K2=IF(IFERROR(SUM(MMULT(COLUMN(A:J)^0,FIND(G2:G11,PHONETIC(OFFSET(G2:G11,,{1,2}))))),)=110,"OK","NO")
K2欄位少 OK=IF(IFERROR(SUMPRODUCT(MATCH(G2:G11,H:H,)+MATCH(G2:G11,I:I,)),)=130,"OK","NO")
留言
張貼留言