0

This question already has an answer here:

I have all data in one sheet and I need to filter the imported data to another sheet. How can I do that in one function?

Function to filter data which I use:

=FILTER(A7:C,RIGHT(A7:A,7)="?id=999")

so how to combine this filter function with importrange function?

=IMPORTRANGE("URL", "Template!A16:C")

marked as duplicate by Rubén, serenesat, John C, jonsca Aug 7 at 21:51

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • can you share a copy of your sheet? – user0 Jun 28 at 14:06
0
  • in one go it would be like this:

    =FILTER(IMPORTRANGE("ID", "Template!A16:C"), 
     RIGHT(IMPORTRANGE("ID", "Template!A16:A"), 7)="?id=999")

Not the answer you're looking for? Browse other questions tagged or ask your own question.