二項不重複數 (9194)

E2{=SUM((B$1:B$10=D2)/COUNTIFS(A:A,A$1:A$10,B:B,B$1:B$10))

另解{=COUNT(0/(B$1:B$10=D2)/(MATCH(A$1:A$10&B$1:B$10,A$1:A$10&B$1:B$10,)=ROW($1:$10)))

另解{=SUM((B$1:B$10=D2)*(MATCH(A$1:A$10&B$1:B$10,A$1:A$10&B$1:B$10,)=ROW($1:$10)))