CountIF Unique Terms + Condition

[m99jones]

Hi -
Hoping you can help with the following excel formula challenge:
I am trying to do a count if of unique names given one criteria
The sample data set is below
I am trying to come up with a formula that shows for Europe I have 1 unique name; For Asia I would get a unique count of 2 unique names.
Any ideas?
Thanks...

Name 1 -> Europe
Name 2 -> Asia
Name 1 -> Europe
Name 3 -> Asia
Name 3 -> Asia

 

[James006]

Hi,

With your data located in range A2:B6

You can test following Array Formula :

=SUM(--(FREQUENCY(IF(B2:B6="Asia",MATCH(A2:A6,A2:A6,0)),ROW(A2:A6)-ROW(A2)+1)>0))

Hope this will help