Performing Contains function in Advanced Filter

4 followers
0
Avatar

I am utilizing the Advanced Filter and am unable to figure out how to perform the CONTAINS function that can be used in the Simple Filter. 

 

How would the syntax go in my Advanced Filter if i were to want to see if my column labeled #Pizza

CONTAINS Pepperoni OR CONTAINS Ham

 

Similarly what would the syntax be for DOES NOT CONTAIN?

 

Thank you!

Matthew Burns

5 comments

  • Avatar
    Alan Mark

    Hi Matthew,

    CONTAINS(#Pizza; "Pepperoni") || CONTAINS(#Pizza; "Ham")

    Will find if your #Pizza contains Pepperoni or Ham.

    If you want both Pepperoni and Ham you would do:

    CONTAINS(#Pizza; "Pepperoni") && CONTAINS(#Pizza; "Ham")

    If you don't want either Pepperoni or Ham:

    NOT(CONTAINS(#Pizza; "Pepperoni")) || NOT(CONTAINS(#Pizza; "Ham"))

    If you don't want Pepperoni and Ham to appear together:

    NOT(CONTAINS(#Pizza; "Pepperoni")) && NOT(CONTAINS(#Pizza; "Ham"))

     

    1
  • Avatar
    Matthew Burns

    Hello Alan,

    What a speedy response!

    Thank you! exactly what I was looking to accomplish!

     

     

    0
  • Avatar
    Joel Stewart

    siva, no, the filters must reference columns within the sheet. If you need to reference data from another sheet, bring it into the working sheet as a first step before adding the filter on that criterion.

    0
Please sign in to leave a comment.