title: google spreadsheets FILTER multiple ranges/columns (A13:B and E13:G)
body: <p>I was wondering if it's possible to use multiple ranges/columns when using FILTER</p>
  
  <p>Right now I'm simply using the formula multiple times, like so:</p>
  
  <pre><code>=filter((Sheet1!A13:B),Sheet1!N13:N&gt;E2,not(iferror(search("AS -", Sheet1!O13:O))))
  
  =filter((Sheet1!E13:G),Sheet1!N13:N&gt;E2,not(iferror(search("AS -", Sheet1!O13:O))))
  </code></pre>
  
  <p>I'm wondering if something like this would be possible (example below doesn't work)?</p>
  
  <pre><code>=filter((Sheet1!A13:B,Sheet1!E13:G),Sheet1!N13:N&gt;E2,not(iferror(search("AS -", Sheet1!O13:O))))
  </code></pre>
  
  <p>I know using QUERY is easier in this case, but I'd like to know if I can do the same with FILTER (since I haven't been able to figure it out)</p>