C2:F4{=INDEX($A:$A,SMALL(IF((COUNTIF($C$1:$F1,$A$2:$A$99)=0)*(COUNTIF($B2:B2,$A$2:$A$99)=0)*($A$2:$A$99<>""),ROW($2:$99)),RANDBETWEEN(1,COUNTA($A:$A)-ROW(A1)*4+4-COLUMN(A1))))
G2{=INDEX(A:A,SMALL(IF((COUNTIF(C$2:F$4,A$2:A$99)=0)*(A$2:A$99<>""),ROW($2:$99),99),ROW(A1)))&""
I2{=AND(COUNTIF(C:G,OFFSET(A2,,,COUNTA(A:A)-1))=1)
留言
張貼留言