SOLVED

COUNTA(UNIQUE(FILTER(

Occasional Contributor

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(FILTER('Iri Comp Data'!$H:$H,ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!$L:$L,ISNUMBER(SEARCH("<>Voila",'Iri Comp Data'!$L:$L

 

I believe the issue is that I can't use <>. The problem is in my data set in Column there is Voila by Sobeys and I don't want to include those in my count.

 

Thank you!

 

1 Reply
best response confirmed by Renattae_Schmidt (Occasional Contributor)
Solution

@Renattae_Schmidt 

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)))))