13 янв. 2018 г. · I have a problem with an OR logic in a query. I'm trying to make a sum of a column (D), if ... column A = cars/build-price/carselector.html.

20 мар. 2023 г. · I want to search specific product name from a range of data having 2 col, col1 is product name and col2 is product category.

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.

10 февр. 2023 г. · In column A (see below), the texts are separated by comma, and now I want to use a query to find all the rows that contains test 1 but not the rows with test ...

7 июн. 2021 г. · I am trying to adapt the query to be able to bring back rows of information whenever another column contains certain criteria (partial match).

9 янв. 2017 г. · I want to run a query which will select data from this range only if it names is inside this list: Select C Where A "is in the selected array of names"

3 окт. 2020 г. · Query's matches in Google sheets web app(unlike official mobile apps) doesn't seem to support regex flags like single line mode: (?s) .

28 нояб. 2022 г. · A formula-driven solution that pulls data on certain properties, specified by a comma-separated literal string like "Property 2,Property 5".

24 авг. 2020 г. · I'm using a query function to copy over rows if it contains any text and/or numbers from column 12 (this column contains addresses).

22 июл. 2024 г. · I've got a sheet with a column of cells that all contain unique text, but they are all different combinations of pre-determined phrases.