title: Advanced Filter returning wildcard data (no wildcards used)
body: <p>I've got a large data set I'm using Advanced Filter to sort through. It's working well for the most part but I've come across an issue I'm not really sure how to deal with.</p>
  <p>I have a list of criteria that corresponds to what is in the data table,</p>
  <p>Let's say the criteria are
  Food - Dessert - Apple</p>
  <p>Advanced Filter is returning not just all the results for &quot;apple&quot; but also for &quot;apple pie&quot;, &quot;apple cobbler&quot; etc.</p>
  <p>Is there a way I can set this to only return the term being searched for rather than including records that also contain that string?</p>
  <p>I've tried inserting quotations around it but that predictably failed.</p>
  <p>If anyone has any ideas I'd be very appreciative.</p>
  <p>Thanks!</p>
  <pre><code>Dim Grp1Criteria As Range: Set Grp1Criteria = WsCriteriaSheet.Range(&quot;A1&quot;).CurrentRegion
  
      If DataSheet.FilterMode Then
          DataSheet.ShowAllData
      End If
      
      WholeMainTable.AdvancedFilter xlFilterInPlace, Grp1Criteria
  </code></pre>
  <p>Note: Current region is isolated so that it's only containing the criteria and the headers corresponding columns in the data table</p>