隨機拆成格數 等於加總 (15044)

D2:D16 區域數組公式{=TEXT(MMULT(N(ROW(1:15)=TRANSPOSE(RANDBETWEEN(ROW(INDIRECT("1:"&B2))^0,B6))),ROW(INDIRECT("1:"&B2))^0),"0;;")

B10=SUMPRODUCT((0&D2:D16)*1)