隨機取全部不重複 依數據數 (11604)

C2{=IF(B2="","",INDEX(B:B,SMALL(IF(COUNTIF(C$1:C1,B$2:B$999)=0,ROW($2:$999)),RANDBETWEEN(1,COUNTA(B:B)-ROW(A1)))))

E2=SUMPRODUCT(COUNTIF(C:C,B2:B20))=COUNTA(B:B)-1