5 Replies Latest reply on Nov 22, 2016 12:29 PM by David Li

    Wildcard Match

    Matthew Hefferon

      Hey guys!

       

      I have a workbook that contains store numbers. We want to use those store numbers as a wildcard match quick filter. Most of the time our users know what store they want so we want the filter to default to exact match and not contains.

       

      For example I want store 117 but when I search 117 I get contains by default:

      wildcard match.PNG

       

      I know we can have our users enter the store number in quotes "117" to get the exact match but wanting the opposite behavior:

      wildcard match quotes.PNG

       

       

      So my question is can I do an exact match without having to put the store number in quotes? Any ideas on how to do this would be appreciated!

       

      Attached is the sample workbook.

       

      Thanks