8 дек. 2019 г. · It selects a cell from column A where column B contains certain text, and I am limiting the output list of values returned to just 10 rows. That all works fine.

18 мар. 2023 г. · Instead of doing "where Col5 matches" is it possible to do "Where Col5 contains"? That way if 1 cell contains either Word E, Word F or Word G it will still ...

13 окт. 2020 г. · I'm trying the following query: =QUERY(A:H,"select G where B contains 'TOTAL'") and also =QUERY(A:H,"select G where B matches 'TOTAL'") There are many

23 июн. 2020 г. · I am trying to run a query that will allow users to look up information from the database. I have created a working function for this for looking up ...

9 янв. 2022 г. · My aim is to use a query to select all of the rows where the quantity column contains a number. This one isn't doing the trick.

31 июл. 2019 г. · I'm trying to vlookup where a column contains "budget-custom" but does not contain "-BuyOnline", "-Conquest", "-Pace", "-UsedDNM","-NonFranchise Service".

17 мая 2019 г. · I want to do a query or perhaps a different function would be best, where I select the contents of column x, y and z where any 1 of 100 columns contains a ...

24 мар. 2019 г. · I have this query formula. =query({Liverpool!B10:B,Liverpool!A10:F}, " select Col2, Col3, Col4, Col5, Col6, Col7 where Col1 is not null and Col6 contains '

23 июл. 2019 г. · I am using the following formula: =QUERY(sheet1!A:A,("select A where not A contains '"&sheet2!A:A&"'")) what it does, it only excludes the word in first cell.

4 дек. 2021 г. · I need to Query column A and a column that contains one specific location name with all the data included in that column. And exclude cells that are equal to 0.