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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With