So I got a excel sheet that lists (amongst other things) organizations and the year they were active in. Some organizations were active more than once a year. It looks like this:
YEAR -- ORGANIZATION
2015 --- Orga A
2015 --- Orga A
2015 --- Orga B
2014 --- Orga C
2014 --- Orga C
2013 --- Orga D
2013 --- Orga D
I'm trying to figure out a formula that will give me the number of unique organizations active per year (in the example: 2 in 2015, 1 in 2014, 1 in 2013).
What I've tried: I created a new column in C, and entered this formula in each row:
=COUNTIF($B$2:B*X*,B*X*)=1
X = 2 (B2), in the first row, and than rises by 1 per row (e.g. B2, B3, B4) That will output whether it is the first time that the organization was active (as YES/NO).
With this I can then create a simple COUNTIF formula that will count the number an organization was active. The problem is however that this refers to whether the organization was active in all years more than once, not per individual year.
Writing the above mentioned function for every year is not an option, as the sheet should be sort of "self-sustaining", as it is an on-going list that will need to accommodate future years.
I feel like this could be solved with an array formula and an IF function, but I'm unsure how... Any input would be hugely appreciated! (: