隨機產生 剩余天数數值 (Randomly generated remaining days value) (11814)

B2:B16 区域数组公式{=TEXT(MMULT(N(TRANSPOSE(RANDBETWEEN(ROW(INDIRECT("1:"&G2-G3))^0,G4))=A2:A16),ROW(INDIRECT("1:"&G2-G3))^0),"0;;")

区域数组公式 :公式下B2-->ENTER-->圈選B2:B16-->游標放公式上-->shift+ctrl+enter三鍵一起按-->按F9就變 -->要固定-->複製-->原處選擇性貼上-->值(Area array formula: B2 under the formula-->ENTER-->circle B2:B16-->place the cursor on the formula-->press shift+ctrl+enter together-->press F9 to change-->to be fixed -->Copy-->Paste selectively in place-->Value)