B2:G6{=SUBSTITUTE(SUBSTITUTE(RIGHT(0&0&SUM(MID(B$1&SUM(LARGE(IF(ISERR(FIND(ROW($1:$10)-1,B$1)),ROW($1:$10)-1),{1,2})*{10,1}),RIGHT(SMALL(RANDBETWEEN(ROW(1:5)^0,999)/1%+ROW($1:$5),ROW($1:$5))),1)*10^{4;3;2;1;0}),5),LARGE(IF(ISERR(FIND(ROW($1:$10)-1,B$1)),ROW($1:$10)-1),2),"X"),MAX(IF(ISERR(FIND(ROW($1:$10)-1,B$1)),ROW($1:$10)-1)),"X")
數字不可有 0{=SUBSTITUTE(RIGHT(0&0&SUM(MID(B$1&0&0,RIGHT(SMALL(RANDBETWEEN(ROW(1:5)^0,999)/1%+ROW($1:$5),ROW($1:$5))),1)*10^{4;3;2;1;0}),5),0,"X")
留言
張貼留言