隨機指定出現 1次數 (10649)

E2:X2 區域數組 下拉 {=(RIGHT(SMALL(RANDBETWEEN(ROW(1:20)^0,999)/1%%+ROW($1:$20),COLUMN(A:T)),4)-D2<=0)*1

C2:C7=SUM(E2:X2)