I need a formula that counts only unique values based on a third criteria.
So I got a excel sheet that lists different organizations, the location they were active in, and the year they were active in. Some organizations were active in multiple years.
So the formula needs to count the number of unique organizations that were active in a specific district over time. This cannot count organizations twice if they were active there more than one time.
The table looks something like this:
YEAR ORGANIZATION LOCATION 2015 Orga A Germany 2015 Orga B France 2015 Orga A Germany 2014 Orga C Poland 2013 Orga D Germany
... and I need a formula that will tell me that the number of active, unique organizations in Germany is 2.