隨機產生指定數字與次數 (10891)

B7:K8=RAND()

B2:K3=CHOOSE(LOOKUP(RANK(B7,$B$7:$K$8),{1,5,9},{1,2,3}),RANDBETWEEN(30,35),RANDBETWEEN(-35,-30),RANDBETWEEN(-29,29))

N2:N3=COUNTIF(B$2:K$3,LEFT(M2,ROW(A1)+3))

格式化 B2:K3=B2<=-30

格式化 B2:K3=B2>=30