請問一下01這邊的大神們
我在某一格使用了以下公式
=CHOOSE(RANDBETWEEN(1,4),"A","B","C","D")
這樣會跑出A、B、C、D其中一個
但是我將這個公式複製了10格
我希望這10格裡面，ABCD四個選項的出現次數皆不超過五次
次數可以是0~5次
請問有什麼方法可以達成這樣子的抽樣的需求嗎?
10格裡面前4格可以用樓主的公式去做
第5(n)格以後就去判斷前面格子(1~n-1)的各字母數有沒有超過3, 有的話就換亂數其他字母
=IF(COUNTIF(C$13:C16,"A")>3,
CHOOSE(RANDBETWEEN(1,3),"B","C","D"),IF(COUNTIF(C$13:C16,"B")>3,
CHOOSE(RANDBETWEEN(1,3),"A","C","D"),IF(COUNTIF(C$13:C16,"C")>3,
CHOOSE(RANDBETWEEN(1,3),"A","B","D"),IF(COUNTIF(C$13:C16,"D")>3,
CHOOSE(RANDBETWEEN(1,3),"A","C","B"),CHOOSE(RANDBETWEEN(1,4),"A","B","C","D")))))
內文搜尋
從 APP 打開
X