縱橫不重複 依指定數字 (11943)

A2:O21区域数组公式{=IF((COLUMN(A:O)>Q2)+(ROW(1:20)>Q6),"",RIGHT(SMALL(RANDBETWEEN(ROW(INDIRECT("1:"&Q2*Q6))^0,999)/1%%+ROW(INDIRECT("1:"&Q2*Q6)),(ROW(INDIRECT("1:"&Q6))-1)*Q2+TRANSPOSE(ROW(INDIRECT("1:"&Q2)))),4)*1)



留言