Unique text values times two

[wyrm76]

Hello to all,

I just stumbled on this site in desperation because I am fighting with Excel all morning. I hope someone can help me.

I have a huge datasheet from which I am trying to make some graphs. Here's the challenge I am facing:

Column AZ holds the name of a customer, column BC the location of the customer. Names of the customers can be listed multiple times, and I am searching for a way in which I can see how many customers there are for a location. This would lead me to a graph that shows the ammount of active customers per location.

customer| location
a | New york
a | New York
b | New York
c | New York
d | Paris
d | Paris
e | Amsterdam

The Result should be:
New York: 3
Paris: 1
Amsterdam: 1

To make it even more difficult. Some fields contain just Amsterdam, others Amsterdam-west. So searching for texts containing Amsterdam would be great.

 

[wyrm76]

The weird thing is that the online version of Excel gives me a 0, my desktop version gives me a #VALUE ?

 

[wyrm76]

Did you confirm it with Ctrl Shift Enter?

Yes, that's it. Thanks eveyone!

 

[Fluff]

You're welcome & thanks for the feedback.