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

	31
	31
	32
	32
	33
	33
	33
	34
	35
	36

<tbody>
</tbody>

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.