title: Filter an excel range based on multiple dynamic filter conditions
body: <p>I would like to filter a dataset considering several filter condition that can change dynamically based on a list of possible values. I have filter criteria <strong>team</strong> which have the following values: <code>Team A</code>, <code>Team B</code>, <code>ALL</code>, where ALL is a wildcard representing all teams. For the second criteria <strong>release</strong>, in case I want to include more than one release in the filter, the values are separated by comma, for example: Release: <code>A</code>, <code>B</code>, <code>A,B</code>, where the last one means to include both release A and B. I was able to make it works except for the case when the release value is <code>A,B</code>.</p>
  <p>I think I should use: <code>TRANSPOSE(TEXTSPLIT(B4,&quot;, &quot;))</code> to obtain in a column the list of values and then in some how (maybe using <code>MMULT</code>) to be able to add the filter condition per each row, but I was not able to do it (in Excel, because using Google Spreadsheet I was able to do it using a query function)</p>
  <p>The following formula for single release value works for both criteria:</p>
  <pre><code>FILTER(D3:H8, (IF(B3=&quot;ALL&quot;, D3:D8&lt;&gt;&quot;*&quot;,D3:D8=B3)) * (E3:E8=B4))
  </code></pre>
  <p>but it doesn't work for the general case where release values are more than one.</p>
  <p>I am looking for a solution that would not require a VBA script</p>
  <p>Here is the sample file:
  <a href="https://i.stack.imgur.com/r4zhr.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r4zhr.jpg" alt="Dynamic Filter Sample" /></a></p>
  <p>Here is a link to the sample excel file:
  <a href="https://1drv.ms/x/s!AlZxw2GG3C7IhyhTnBFbln1G8fOj?e=C8OUxn" rel="nofollow noreferrer">https://1drv.ms/x/s!AlZxw2GG3C7IhyhTnBFbln1G8fOj?e=C8OUxn</a></p>