不重複數據取出 不含括弧 (12855)

D2{=IFERROR(-LOOKUP(1,-LEFT(INDIRECT(TEXT(SMALL(IF(COUNTIF(D$1:D1,LEFT(A$2:B$9,FIND("(",A$2:B$9)-1))=0,ROW($2:$9)/1%+{1,2}),1),"!R0C00"),),ROW($1:$9))),"")

E2=IF(D2="","",SUMPRODUCT(N(LEFT(A$2:B$9,FIND("(",A$2:B$9)-1)-D2=0)))