隨機不重複與依出現次序 取值 (14639)

E2{=INDEX(B:B,SMALL(IF(A$2:A$14=D2,ROW($2:$14),99),COUNTIF(D$2:D2,D2)))

F2{=INDEX(B:B,SMALL(IF((A$2:A$14=D2)*(COUNTIFS(D$1:D1,A$2:A$14,F$1:F1,B$2:B$14)=0),ROW($2:$14)),RANDBETWEEN(1,COUNTIF(A:A,D2)-COUNTIF(D$2:D2,D2)+1)))