O2{=LOOKUP(1,0/(MMULT(1-ISNA(MATCH(COUNTIF(OFFSET(G$1,{1;2;3;4;5},,,{1,2,3}),G$2:I$6)&G$2:I$6,COUNTIF(OFFSET(L2,,,,{1,2,3}),L2:N2)&L2:N2,)),{1;1;1})=3),J$2:J$5)
條件少 OK=LOOKUP(1,0/(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($G$2:$G$6&$H$2:$H$6&$I$2:$I$6,L2,,1),M2,,1),N2,,1)=""),$J$2:$J$6)
留言
張貼留言