How to Get count of Unique Data

Here is the formula, you can get the count of unique numbers in a given data

 

If the data is numbers :

=SUM(IF(FREQUENCY(D6:D44,D6:D44)>0,1))

 

If the data is Text :

=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1))