平均分配 剩餘隨機分配 (15193)

M4:P7=RAND()

H4:K7=(RANK(M4,$M4:$P4)<=MOD($F4,4))+INT($F4/4)

H10:K10區域數組公式 下拉{=(RIGHT(LARGE(RANDBETWEEN(ROW(1:4)^0,99)/1%+ROW($1:$4),COLUMN(A:D)))-MOD(F4,4)<=0)+INT(F4/4)