隨機產生 1與2指定數 (12948)

E6=E4-E5

B2:B23 區域數組公式 {=IF(ROW(1:99)>E4,"",RIGHT(SMALL(2^(ROW(INDIRECT("1:"&E4))>E5)+RANDBETWEEN(ROW(INDIRECT("1:"&E4))^0,99)/1%,ROW(INDIRECT("1:"&E4)))))