Title sums it up, I want to be able to filter an importrange in a single formula, can this be done without importing the range multiple timer in the filter? I want to do this without using a 2nd worksheet to hold the importrange.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 or query an importrange in a single formula without importing the range multiple times or using a 2nd worksheet?
google spreadsheets