I'm working in Google Sheets. I have 3 columns:
ID Region Year 101 US 2014 102 EU 2014 103 US 2014 102 US 2015 102 EU 2014
I would like to count the number of Unique IDs for each year and region. Thus, the results would be:
2014 US: 2 2014 EU: 1 2015 US: 1
Here are the limitations I have to work with:
- I cannot use a Pivot
- I cannot create a separate column to first extract the unique values, and then count those.
I've been trying to come up with a formula using
COUNTUNIQUE, but for some reason, it doesn't seem to be working.