Thanks! What if create a new row (column D) with values in it and I add another criteria wherein the value should be greater than zero for the unique concepts to be counted. What will be the revised formula? I have attached a new file for reference.
In summary, here's the new criteria:
1. Category Code - it will only count the number of unique concepts for that category
2. Time Period - if I select from 1 to 3, then it should sum the number of unique concepts based on time periods 1-3. If I select from 3 to 3, then it would only count the number of unique concepts based on time period 3.
3. Units value - should be greater than zero for the unique concept to be counted.
Bookmarks