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