Stack Overflow
Stack Overflow

Questions tagged [google-sheets-query]

Use for question about the QUERY function of Google Sheets.

Use this tag for questions about the QUERY function of Google Sheets.

QUERY is a non-standard spreadsheet function. It uses Google Query Language

It could be used together with

Usually it will not be used with

1444 questions
2
votes
2 answers

Google Sheet Query statement

Thanks in advance for any help. So here’s my dilemma, this is an example (copy) of a Google sheet with raw data in first tab and I’m trying to extract summary data onto the second…
David Kelly
  • 21
  • 1
2
votes
2 answers

Creating a dynamically sorted and filtered list from a range using a single formula in Google Sheets

I'm trying to do something similar to this question: Google sheets using Filter and Sort together I have an input range with two columns, and as output I want to create a dynamically sorted and filtered list from the input range, using a single…
Shian Han
  • 307
  • 1
  • 5
  • 16
2
votes
2 answers

In Google Sheets, how can one aggregate values (MAX, MIN, AVERAGE) based on the result of splitting a string in a different column?

If I had a table with the following values, how can I generate the following table? The result table separates out each tag and calculates the number of rows with the tag mentioned (COUNT) and also the max value for a given tag. …
JustKash
  • 687
  • 2
  • 13
  • 28
2
votes
4 answers

UNIQUE formula + IF

Looking to combine google sheet unique formula with an If formula. See below. The outcome should be Unique values from column "B" and only active values from column "C". Column B. Column C Sweden Active Sweden Active Spain …
bertathaman
  • 25
  • 1
  • 1
  • 5
2
votes
1 answer

QUERY with double condition in Google Sheets

I have a table similar to this A B C D E a1 b1 5 d1 a2 b2 5 d2 a3 b1 3 e1 a4 b3 4 e2 a5 b1 5 d3 e3 I'm trying to figure out a query that shows A,B,C,D if the value…
Alex
  • 79
  • 1
  • 10
2
votes
2 answers

Get SUM from CATEGORY and by MONTH

So I'm trying to sort some data from a form in google sheets. I need to sort the data by category. and by the month. So far I have been able to sort these individually but not in the same cell. my code so far for my test form is below the…
marksus1
  • 79
  • 1
  • 6
2
votes
1 answer

Google Sheet Query Totaling Minutes within Date Range

I am trying to query a Google Sheet from a separate tab. I want to total minutes, between a certain date range, with a particular userid. I want the dates to be entered by the user as well as the userid. My query is currently: select SUM(Col28)…
Tom Nahas
  • 23
  • 2
2
votes
2 answers

Query to list data that's not listed in another column

=QUERY({startingdates!D2:D, Cancelledtours!D2:D},"Select Col1 where not(Col1) matches Col2") This seems to work for Column A but not column D. I'm at a dead-end. Can anyone help? Sheet-…
user198561
  • 49
  • 4
2
votes
1 answer

Transpose multiple rows into column in Google sheet

I want to use transpose formulae in this data and I want desire output will look like this
Khan
  • 97
  • 1
  • 11
2
votes
1 answer

What does symbols like '♠' mean in a google sheets formula?

So I found this excellent formula to transpose a table in google sheets, but I don't underestand what these symbols stand for '♠', '♦'. This is the formula: =ARRAYFORMULA({"Country", "Date", "CM1"; …
Caro G
  • 21
  • 4
2
votes
1 answer

Query rows with most recent time stamp in Google Sheets

I have some data in Google Sheets that contains duplicate account numbers with different dates. I want to query the data and to remove the duplicates, and select only those rows with the most recent date. Sample data is here: 115684 11/21/2019 …
Carlo B.
  • 119
  • 2
  • 16
2
votes
1 answer

Decimals in Query formula in Google Sheets

I'm trying to make a query formula. =QUERY(namedRange;"SELECT F WHERE 2.6 > D AND 2.6 < E") This works, but when I'm using a column reference like E7 it doesn't work. The value in E7 is 2,6. I know the comma breaks the…
amrz one
  • 124
  • 1
  • 9
2
votes
2 answers

How to transpose this data in Google Sheets

I have data in google sheet I just want to fetch that data in my other sheet but in transpose Here is ex: Column A | Column B | Column C ================================= site1.com | Name 1 | Name 2 site2.com | Name 3 | Name 4…
hardy
  • 537
  • 1
  • 5
  • 19
2
votes
1 answer

Search a range and bring back a stacked column of results

I know this is possible using a combination of probably =FILTER, ARRAYFORMULA and probably QUERY but hopefully, the examples will explain it better than words can. Effectively, I have an output (the top table) and I want the formula that will bring…
Adam Lough
  • 23
  • 2
2
votes
1 answer

Google Sheets Query sum indeterminate number of columns

select sum(Col1),sum(Col2),sum(Col3) ... up to 500 columns but the number might increase or decrease... what is the best way to go about this with one formula? it would be really nice if you could just do select sum(*) ... but sadly that does not…
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
1 2 3
…
96 97