11,820 views
Step by step guide to using the query function in conjunction with the importrange function in Google Sheets. And filter data from another Google spreadsheet automatically. In this example, we work with two filter criteria within the Query function. And to make the filter easier, we create drop-down lists based on the data from the other spreadsheet, using the Unique function in conjunction with the ImportRange function. Working with the query and ImportRange functions makes it easier to manipulate data from another Google spreadsheet. ✅SGP Website: Sale of a Collection of Ready-Made Google Spreadsheets: https://planilhascanalsgp.com.br/plan... ===============