隨機緊接產生 不重複1到指定數 (14792)

D2下拉{=SMALL(IF(COUNTIF(D$1:D1,ROW(INDIRECT("1:"&B$2)))=INT((ROW(A1)-1)/B$2),ROW(INDIRECT("1:"&B$2))),RANDBETWEEN(1,B$2-MOD(ROW(A1)-1,B$2)))

D欄 格式化=MOD(COUNTIF(D$2:D2,D2),2)=0