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.