count and ignore duplicates

[bongobus]

whats best way to achieve the following

in column B I have numbers that accumulate and some can be the same example

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]31
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]31
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]32
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]32
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]33
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]33
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]33
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]34
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]35
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]36
[/TD]
[/TR]
</tbody>[/TABLE]

I would like A1 to be the result of counting frequency ignoring the duplicates therefore in this case answer 6

 

[Joe4]

Take a look here: https://support.office.com/en-us/ar...plicates-8d9a69b3-b867-490e-82e0-a929fbc1e273

 

[Aladin Akyurek]

In A1 enter:

=SUM(IF(FREQUENCY(B2:B11,B2:B11),1))

 

[bongobus]

In A1 enter:

=SUM(IF(FREQUENCY(B2:B11,B2:B11),1))

Perfect Thankyou Aladin Akyurek

 

[Aladin Akyurek]

Perfect Thankyou Aladin Akyurek

You are welcome.