每个月姓名不重复的个数 (9887) 日期: 4月 25, 2022 取得連結 Facebook Twitter Pinterest 以電子郵件傳送 其他應用程式 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)) 留言
留言
張貼留言