I want to do this without using a second worksheet to hold the imported range.
ie. Filter(myimportRange, importrangepart = mycondition)
since this has to import the range twice.
I also cannot seem to query the IMPORTRANGE since this results in blank cells as seen here:
Can I filter an IMPORTRANGE in a single formula without importing the range multiple times in the filter?