How to combine these funcions (FILTER + IMPORTRANGE) in one? [duplicate]

Question

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 — user0, Jun 28 '19 at 14:06

user0 · Accepted Answer · 2019-06-28 14:09:44Z

0

in one go it would be like this:

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

answered Jun 28 '19 at 14:09

user0

21k7 gold badges33 silver badges53 bronze badges

add a comment |

1 Answer 1