隨機組合 1~9 (14399)

B2{=SUM(RIGHT(SMALL(RANDBETWEEN(ROW(1:9)^0,999)/1%+ROW($1:$9),ROW($1:$9)))*10^(ROW($1:$9)-1))

C2=AND(ISNUMBER(FIND(ROW($1:$9),B2)))*1



留言