抽全勤者 (9276)

E2{=IF(ROW(A1)>G$2,"",IFERROR(INDEX(B:B,SMALL(IF((C$2:C$16<>"")*(COUNTIF(E$1:E1,B$2:B$16)=0),ROW($2:$16)),RANDBETWEEN(1,1+COUNTIF(C:C,"全勤")-ROW(A1)))),""))

格式化 B2:C16=COUNTIF($E:$E,$B2)