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:

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

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