小白求助，如何将5个A，7个B，4个C随机分配到4x4的格子内

=CHAR(INDEX(RIGHT(SMALL(MID(CONCAT(REPT(ROW(1:3),{5;7;4})),ROW(1:16),1)+RANDARRAY(16,1,10,90,1)*10,ROW(1:16)),1),SEQUENCE(4,4))+64)

=MID(CONCAT(REPT({"A","B","C"},{5,7,4})),MOD(SMALL(RANDBETWEEN(ROW(1:16)^0,100)/1%+ROW($1:$16),(ROW($1:$4)-1)*4+COLUMN($A:$D)),100),1)
区域数组