Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

google spreadsheets FILTER multiple ranges/columns (A13:B and E13:G)

Tags:

I was wondering if it's possible to use multiple ranges/columns when using FILTER

Right now I'm simply using the formula multiple times, like so:

=filter((Sheet1!A13:B),Sheet1!N13:N>E2,not(iferror(search("AS -", Sheet1!O13:O))))

=filter((Sheet1!E13:G),Sheet1!N13:N>E2,not(iferror(search("AS -", Sheet1!O13:O))))

I'm wondering if something like this would be possible (example below doesn't work)?

=filter((Sheet1!A13:B,Sheet1!E13:G),Sheet1!N13:N>E2,not(iferror(search("AS -", Sheet1!O13:O))))

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)


Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!