0

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")
  • can you share a copy of your sheet? – user0 Jun 28 '19 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.