随机生成指定个数與列数 (9017)

F2 右拉 下拉 (由上往下){=IFERROR(IF((COLUMN(A1)>$B$2)+(ROW(A1)>ROUNDUP($B$1/$B$2,)),"",SMALL(IF((COUNTIF($F$1:$K1,ROW(INDIRECT("1:"&$B$1)))=0)*(COUNTIF($E2:E2,ROW(INDIRECT("1:"&$B$1)))=0),ROW(INDIRECT("1:"&$B$1))),RANDBETWEEN(1,$B$1+1-(ROW(A1)-1)*$B$2-COLUMN(A1)))),"")

M2 右拉 下拉 (由左往右){=IFERROR(IF((COLUMN(A1)>$B$2)+(ROW(A1)>ROUNDUP($B$1/$B$2,)),"",SMALL(IF((COUNTIF($L$2:L$16,ROW(INDIRECT("1:"&$B$1)))=0)*(COUNTIF(M$1:M1,ROW(INDIRECT("1:"&$B$1)))=0),ROW(INDIRECT("1:"&$B$1))),RANDBETWEEN(1,$B$1+1-ROW(A1)-(COLUMN(A1)-1)*ROUNDUP($B$1/$B$2,)))),"")

B4{=AND(COUNTIF(F:K,ROW(INDIRECT("1:"&$B$1)))=1)

B5{=AND(COUNTIF(M:R,ROW(INDIRECT("1:"&$B$1)))=1)