Counting the unique values in a range.

[DSNTNOENUF]

Can someone assist with a formula that will look at column B and count the unique value for the range.

for example in column B below the answer is two (2) as 25 appears at least once and 6 appears at least once.

My sincere thanks in advance.

A	B
1	25
2	6
3	6
4	6
5	6
6	6

<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

 

[Joe4]

See this: https://exceljet.net/formula/count-unique-values-in-a-range-with-countif

 

[DSNTNOENUF]

See this: https://exceljet.net/formula/count-unique-values-in-a-range-with-countif

Thank-you so much!!!!!

 

[Joe4]

You are welcome!