Forum Discussion
Solved
COUNTA(UNIQUE(FILTER(
Hello all, I am trying to write a formula that will counts the number of unique values in Column L:L assuming there filter Sobeys and not Voila. The below is my formula: =COUNTA(UNIQUE(...
The formula isn't complete, but it should probably look like
=COUNTA(UNIQUE(FILTER('Iri Comp Data'!$H:$H,ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!$L:$L))*ISERROR(SEARCH("Voila",'Iri Comp Data'!$L:$L)))))
The formula isn't complete, but it should probably look like
=COUNTA(UNIQUE(FILTER('Iri Comp Data'!$H:$H,ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!$L:$L))*ISERROR(SEARCH("Voila",'Iri Comp Data'!$L:$L)))))