隨機產生不重複 指定起止數 (設輔助 簡單) (12858)

B15:K24=IF(ROW(A1)*10-11+COLUMN(A1)>$N$3-$N$2,"",RAND())

B2:K11=IF(B15="","",RANK(B15,$B$15:$K$24)+$N$2-1)

N6=AND(COUNTIF(B:K,ROW(INDIRECT(N2&":"&N3)))=1)