title: Auto filter with multiple wildcards
body: <p>Is there a way to use an Excel auto filter, whereby you set a predefined list of values to filter by, and it will return all the cells in a column that contain that phrase? For example imagine the data below (all in a single column).</p>
  
  <pre><code>       A
  1    NAMES
  2  Brian
  3  Brian, John
  4  Brian, Mark
  5  Mark, John
  </code></pre>
  
  <p>The filter would have three predefined values, <code>Brian</code>, <code>John</code> and <code>Mark</code>, when you select either 1 or more options, it satisfies all selected filters? So in this example <code>Brian</code> would return the first three cells, where as selecting <code>Mark</code> and <code>John</code> would return only the last.</p>
  
  <p>I know this is possible to do once in a list of data using the <code>Advanced Filter</code>, but I'm looking for a real-time way of doing this many times.</p>