随机各班各等级抽取 (10784)

E2=LOOKUP(D2,COUNTIF(A:A,A2)*{0,3,6,9}/10+0.01,{"优","良","中","差"})

G2=RAND()

F2=IF(COUNTIFS(A:A,A2,E:E,E2,G:G,">"&G2)<=(E2<>"差")*1,"V","")

格式化 (A班F列空白) E2:F21=($A2="A")*($F2="")