有指定字樣 取不重複 (13272)

C2{=INDEX(A:A,MIN(IF(MMULT(1-ISERR(0/(FIND(TRANSPOSE(E$2:E$9),"@"&A$2:A$22)>1)),ROW(1:8)^0)*(COUNTIF(C$1:C1,A$2:A$22)=0),ROW($2:$22),99)))&""



留言