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.

[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]B[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]25[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!