顧客的科室 都有W與Z 提取 (12961)

D2{=INDEX(A:A,SMALL(IF((MMULT(1-ISNA(MATCH(A$2:A$16&{"W","Z"},A$2:A$16&B$2:B$16,)),{1;1})>1)*(MATCH(A$2:A$16,A:A,)=ROW($2:$16)),ROW($2:$16),99),ROW(A1)))&""