随机抽取不重複 (9440)

F6:F9{=INDEX(A:A,SMALL(IF((B$2:B$20=E6)*(COUNTIF(F$5:F5,A$2:A$20)=0),ROW($2:$20)),RANDBETWEEN(1,COUNTIF(B:B,E6)+1-COUNTIF(E$6:E6,E6))))

格式化 A2:B20=COUNTIF($F:$F,$A2)