Log In
Register
Home
October 26, 2013
Offline
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 .
VIP
Trusted Members
December 7, 2016
Offline
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
1 Guest(s)
