Hi
I require to count unique entries in excel albeit on satisfying two criterias. My data is organised like this:
Col A Col B
A Jun
A July
A Aug
B Jun
B Jul
B Jul
C Jun
C Aug
Now I want a unique count of entries in column A that fall BOTH in June AND July. So in the above case value A comes in June and July therefore the count for A should be 1. Similarly B also falls in Jun and July so the count should be 1 for B as well. However C comes in June but not in July and hence the count for C should be 0. So the final answer should be 2 achieved as (1+1+0). I would like to extend this formulae to include more criterias. Request someone to kindly help.