二數據 無出現 取出 (15175)

D2:E8{=INDEX(A:A,MIN(IF((COUNTIF($A:$B,A$2:A$12)-COUNTIF(A:A,A$2:A$12)=0)*(COUNTIF(D$1:D1,A$2:A$12)=0),ROW($2:$12),99)))&""

另解{=INDEX(A:A,MIN(IF((COUNTIF(OFFSET($B$2:$B$12,,-(A$1=$B$1)),A$2:A$12)=0)*(COUNTIF(D$1:D1,A$2:A$12)=0),ROW($2:$12),99)))&""