Count 1 of each value in a range containing duplicate values

[itzzjason]

What formula can be used to count 1 of each value in a given range?

Using Microsoft Office Home and Business 2016

Please see below example table.
I'd like to count how many apartments are on the list without counting duplicates. So the formula would give a count of 5 for this table.

	A	B	C
1	Date	Apt. #	Name
2	5/25/22	2A	John
3	5/25/22	2A	Jason
4	6/1/22	7B	Jack
5	7/1/22	21G	Irene
6	5/30/22	21G	Jennifer
7	6/30/22	21G	Elizabeth
8	6/15/22	9H	Steve
9	5/15/22	10C	Angela

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[itzzjason]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Office Home and Business 2016

 

[Fluff]

If you are using 2016 why have you also shown 365 in your profile?

How about

=SUMPRODUCT(1/COUNTIFS(B2:B9,B2:B9))

 

[itzzjason]

If you are using 2016 why have you also shown 365 in your profile?

How about

=SUMPRODUCT(1/COUNTIFS(B2:B9,B2:B9))

I have multiple PCs spanning across work and personal life. Depending on which office I work out of/desktop I use, it can have 365, 2016 (today's desktop), and another version that I can't remember (could be 2019). At home, I think I have 2019. Sometimes I use Google Sheets for both personal and work too.

 

[Fluff]

Ok, in that case it would be best if you specify which version you are using if it's not 365.