统计不同账号个数 (10608)


H3{=COUNT(0/(A$3:A$55=F3)/(MATCH(A$3:A$55&B$3:B$55,A$3:A$55&B$3:B$55,)=ROW($1:$53)))


另解=COUNT(FREQUENCY(ROW(A:A),MATCH(B$3:B$66&"",B$3:B$66&"",)*(A$3:A$66=F3))^0)-1


留言