A2:J11{=CHAR(SMALL(IF(ISNA(MATCH(LARGE({31,64,96}+ROW($1:$26),COLUMN($A:$BJ)),IFERROR(CODE($L$2:$L$9),9),)),LARGE({31,64,96}+ROW($1:$26),COLUMN($A:$BJ))),RANDBETWEEN(1,62-COUNTIF($L$2:$L$9,"<>"))))
N2=SUMPRODUCT(FREQUENCY(CODE(A2:J11),{47,57,64,90,96,122})*MOD(ROW(2:8),2))
N3=SUMPRODUCT(ISNA(MATCH(CODE(A2:J11),CODE(L2:L9),))*1)
留言
張貼留言