title: Excel filter Multiple Value in One Cell
body: <p>I am looking for help on filtering multiple values in one cell delimited by a comma. 
  For example I have a spreadsheet with the following data:</p>
  
  <pre><code>Column A (Risk)     Column B (Risk Mitigation)
  
  Risk A               Requirement1, Requirement2
  
  Risk B               Requirement2, Requirement6, Requirement7
  
  Risk C               Requirement1, Requirement3, Requirement9
  </code></pre>
  
  <p>When I filter on the 'Requirement Mitigation' Column I would like to see check boxes for the following:</p>
  
  <pre><code>Requirement1
  
  Requirement2
  
  
  Requirement3
  
  Requirement4
  
  Requirement5
  
  ...
  
  Requirement9
  </code></pre>
  
  <p>So for my example when I only check the Requirement 1 filter box, only 'Risk A' and 'Risk C' rows would be displayed </p>
  
  <p>Currently when I filter it does by the unique cell value, which gives me</p>
  
  <pre><code>Requirement1, Requirement2
  
  Requirement2, Requirement6, Requirement7
  
  Requirement1, Requirement3, Requirement9
  </code></pre>
  
  <p>Please note that above is just an example and I have thousand of individual requirements, so it would not be as simple as having one column per requirement.</p>
  
  <p>I open to any suggestions including creating vbscripts.</p>
  
  <p>Any help would be greatly appreciated.</p>