隨機產生 1~101 缺一數字 (12390)

A14:J23=RAND()

A1:J10{=SMALL(IF(COUNTIF($L$2,ROW($1:$101))=0,ROW($1:$101)),RANK(A14,$A$14:$J$23))

L7{=AND(COUNTIF(L2,A1:J10)=0)*AND(COUNTIF(A1:J10,A1:J10)=1)*AND(A1:J10>=1,A1:J10<=101)