excel唯一值个数7种公式

excel唯一值个数7种公式，带大括号的为数组公式，需要按CTRL+SHIFT+ENTER三键结束输入

1 {=SUM(1/COUNTIF(B1:B44,B1:B44))}

2 {=SUM(N(MATCH(B1:B44,B1:B44,)=ROW(1:44)))}

3 {=SUMPRODUCT((B1:B44<>"")/COUNTIF(B1:B44,B1:B44&""))}

4 =SUMPRODUCT(1/COUNTIF(B1:B44,B1:B44))

5 {=SUM(N(FREQUENCY(B2:B45,B2:B45)>0))}

6 {=SUM(--(MATCH(B1:B44,B1:B44,)=ROW(1:44)))}

7{ =SUM(--(FREQUENCY(B1:B44,B1:B44)>0))}