统计名字出现次數 (10152)


K2{=COUNT(0/(MATCH(1&A$2:A$9,N(MMULT(N(C$2:G$9=J2),{1;1;1;1;1})>0)&A$2:A$9,)=ROW($1:$8)))


另解{=COUNT(0/FREQUENCY(IF($C$2:$G$9=J2,$A$2:$A$9),ROW($44000:$46000)))


另解=COUNT(0/FREQUENCY(A$2:A$9*(C$2:E$9=J2),ROW(1:99999)))-1


留言