Hello everyone,

I need to count occurrences of text in relation to two columns, ie:

Column A has the names of all companies present in the municipalities of column B, but the criterion should be the column C, with counties already filtered.

The result I seek is: how many companies there are in each municipality (count only once each company in each city).

I uploaded the table here: http://www.sendspace.com/file/nfennx

I do not know what function to use, help!

Best to all
Ludmila