6 февр. 2018 г. · In google sheets, I want to return a row when a cell in column C contains any value in a range on a different sheet. The query below does not work.

26 апр. 2016 г. · You can achieve this by utilizing the MATCHES feature of the QUERY function, which will match via a regular expression Reference.

20 янв. 2021 г. · I want to set up a Query in Google Sheets and want to use cell content as a condition. Is it possible to do sth. like "SELECT * WHERE A ="&C1: ...

2 апр. 2014 г. · I'm attempting to create a formula that works as follows: =QUERY(A1:B20,"select A, sum(B) where A contains 'Apples' or A contains 'Oranges' group by A")

29 янв. 2021 г. · 1st param of query can be referenced only as non-arrayed range like: =QUERY(INDIRECT(A1)) ____ where A1 contains range A1:C arrayed ranges like these are not ...

5 мая 2021 г. · I am trying to query only result that match a pre-defined list in Google Sheets. This formula is working but what if my WHERE list contains thousands of ...

6 апр. 2022 г. · I am using import range using query filter on Google Sheets =QUERY(IMPORTRANGE("range"),"WHERE COL1 = 'SUNBURN'") I want the filtered range at the destination ...

18 мар. 2014 г. · I have a Google Spreadsheet and I want to run a QUERY function. But I want the WHERE statement to check a series of values.

17 янв. 2017 г. · I am trying to write a formula that would pull data based on a selection I made and within the date range I put in as well.

26 апр. 2021 г. · I have this query function, which tries to get rows from different sheets, but it gives me an error and I can't figure out why. Can you please help me with ...