每个月姓名不重复的个数 (9887)


H3{=SUM((B$2:B$99=F3)*(C$2:C$99=G3)/TEXT(COUNTIFS($B:$B,B$2:B$99,$C:$C,C$2:C$99,$D:$D,D$2:D$99),"0;;1"))


另解{=COUNT(0/(MATCH(B$2:B$99&C$2:C$99&D$2:D$99,B$2:B$99&C$2:C$99&D$2:D$99,)=ROW($1:$98))/(B$2:B$99=F3)/(C$2:C$99=G3))


留言