Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
-2
votes
2 answers

Query Removes Date Values

=filter(query(Vendors!$A$3:$M,"select A,B,C,D,E,F,G,H,I,J,K,L,M",1),Vendors!$L$3:$L = "Invited",Vendors!$I$3:$I - Vendors!$G$3:$G <=$F$6) I have the above formula that will query and return the results. However in all date columns I get a random…
J.E.T
  • 27
  • 4
-3
votes
1 answer

Query Dates by Min Max of Percentage

I have two columns. Column A contains 3 dates. Column B contains 3 percentage values. What is the formula then to find the date for the highest vs. the date for the lowest percentage?
HelpMePlease
  • 27
  • 4
-3
votes
1 answer

How to calculate total of partial matches for dataset?

I'm trying to figure out how to calculate when, in a set of rows, any 2 of them match from 3 criteria. So (6 isn't the correct answer, just an example), I would be trying to calculate how many of the rows contained 2 out of the three criteria:…
mubambi
  • 39
  • 3
-3
votes
1 answer

Count how many times appears text across columns

I'm looking for the formula to count how many times appears a color, for example, "red", from B2:D7 if A2:A7 is "B". .
Tes
  • 61
  • 5
1 2 3
…
74
75