去重统计个数

半個檸檬

=SUMPRODUCT(1/COUNTIFS($A$2:$A$39,$A$2:$A$39,B$2:B$39,B$2:B$39)*($A$2:$A$39=$E3))

白鸟是个鸡

=COUNT(0/(MATCH(B$2:B$39,IF($A$2:$A$39=$E3,B$2:B$39),)=ROW($1:$38)))
数组公式，

龙艺广告

公式不对，不存在的怎么还返回1

倥族

F3
=IFERROR(ROWS(UNIQUE(FILTER(B$2:B$39,$A$2:$A$39=$E3))),"")

杨三哥

=SUM(($A$2:$A$39=$E3)/COUNTIFS($A:$A,$A$2:$A$39,B:B,B$2:B$39))

角落里的枫叶

厉害，感谢

白智昀

=COUNT(0/IF(MATCH($E3&B$2:B$39,$A$2:$A$39&B$2:B$39,0)=ROW($B$1:$B$38),ROW($B$1:$B$38)))