隨機 1~9 不重複 (14695)

B2:F10{=SMALL(IF(COUNTIF(B$1:B1,ROW($1:$9))=0,ROW($1:$9)),RANDBETWEEN(1,10-ROW(A1)))

B12:F12=SUMPRODUCT(COUNTIF(B2:B10,ROW(1:9)))