Hi
In this sheet i have values and text with values.. need to get unique count based on the criteria column B and column C without blanks.
I have tried with countA and count formula .. something i am missing there . could you please check the formulas h3:M9 and help me to understand where and what i have missed to apply.
and if possible guide me to do unique count with partial text match without blank .
Thanks in advance .
Hello,
One easy way to solve this issue is to check if the filter results in an error, if so it is because it can't find any matching data to filter by, so in such case set a 0. In other words, in cell H2:
=IF(COUNT(FILTER($A$2:$A$2000,($B$2:$B$2000=$G2)*($C$2:$C$2000=H$1)))=0,0,COUNTA(UNIQUE(FILTER($A$2:$A$2000,($B$2:$B$2000=$G2)*($C$2:$C$2000=H$1)))))
Br,
Anders
Thank you .. its really helpful..
