Performing Contains function in Advanced Filter

Follow

Matthew Burns

• July 13, 2017 23:27

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!

0

• 

  Alan

  • July 14, 2017 14:14
  • Edited

  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

  Comment actions Permalink
• 

  Matthew Burns

  • July 14, 2017 14:08

  Hello Alan,

  What a speedy response!

  Thank you! exactly what I was looking to accomplish!

   

   

  0

  Comment actions Permalink
• 

  siva prasad

  • September 27, 2018 19:56

  Hi 

   

  Can we refer column from other sheet for filter condition 

   

  0

  Comment actions Permalink
• 

  siva prasad

  • September 27, 2018 20:19

  Hi 

   

  Can we refer column from other sheet for filter condition 

   

  0

  Comment actions Permalink
• 

  Joel Stewart

  • September 27, 2018 21:56

  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

  Comment actions Permalink

Please sign in to leave a comment.