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
6
votes
4 answers

Get first non-empty cell in row

In Google Sheets, how do I get the value of the first non-empty cell in the row 17 starting at column C forwards?
mikabytes
  • 1,818
  • 2
  • 18
  • 30
6
votes
2 answers

How to create INDIRECT array string of multiple sheet references in Google Sheets?

I am attempting to use a query to display data off multiple Google Sheets. I make a new sheet every week that has a specific sheet name, e.g. Week of 01/13, Week of 01/06 and so forth. The following is where my idea spawned from for reference: I…
s0m3thlng
  • 61
  • 1
  • 3
6
votes
2 answers

Multiple Sort ( ORDER BY ) within Query in Google Sheets

What am I missing here? =QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B ORDER BY A DESC, B" The data is sorting on Column A, but doing nothing to Column B. Since that didn't work, I also tried building it this way, however I haven't done a vested…
Kristi Miller
  • 61
  • 1
  • 1
  • 5
6
votes
3 answers

Google Sheets query date > today()

I'm trying to filter out dates greater than today. I looked up the syntax but the date-part does not work; I'm still getting dates > today in the results. Could someone help me out with this?! Thank you! Here' the…
GTB- Vlaams-Brabant
  • 61
  • 1
  • 1
  • 3
6
votes
2 answers

VLOOKUP within IMPORTRANGE

I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP: =importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false))) I get a general error. Does…
Luca
  • 848
  • 1
  • 14
  • 33
6
votes
2 answers

Extracting the top five maximum unique values

I am running a Nerf league at a party and want my spreadsheet to show the top five contestants. Contestants are allowed unlimited entries and only their top score is counted. Entries are being collected on Google Sheets and The Top 5 published on a…
James Geddes
  • 742
  • 3
  • 10
  • 35
6
votes
1 answer

QUERY using cell contents as SQL variables

Here is what the spreadsheet I'm working with looks like: Summary table (top of sheet) Source data (same sheet, below output) I'm using the QUERY function to populate the appropriate feeds in the summary table with the data starting at A24 needs…
Jimmy
  • 83
  • 1
  • 2
  • 4
5
votes
2 answers

Convert a string to a formula in Google Spreadsheet

I´d been more than 10 hours reading and trying different options with no success. I have this string (this is actually a string that is generated by other…
Gastón BA
  • 53
  • 1
  • 3
5
votes
1 answer

"Query Completed with an Empty Output" How to get it to put a zero when there are no results instead

My query is yielding an error #N/A Query Completed with an Empty Output. =sum((query(importrange("mysheet","CR"),"select Col7 where Col1 ='"&A4&"' and Col2 ='"&B4&"' and Col13!='Cancelled' and Col13!='Rejected' ",0))) The function is working…
Elizabeth
  • 57
  • 1
  • 8
5
votes
3 answers

SELECT DISTINCT for only one Column in Google Sheets Query

Let's say I have the following query. =query (A:C; "SELECT A, B, C") How can I modify it so that it returns no duplicate A? In other words, when several rows contain the same A, I want the results to include only one of those rows (the last one).…
Lucas Reis
  • 65
  • 1
  • 2
  • 7
5
votes
2 answers

Query returning error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN

I am currently working in the following spreadsheet https://docs.google.com/spreadsheets/d/13KfjUhWSB-BjGyC1G8f8i8o4SPd1kFFLkjN7D6VY8Lk/edit#gid=993210576 In which I am importing data from another worksheet using IMPORTRANGE, and writing a QUERY to…
Dan
  • 53
  • 1
  • 1
  • 5
5
votes
2 answers

What alternatives do I have when encountering IMPORTDATA maximum size error in Google Sheets?

I'm using the IMPORTDATA formula to populate a CSV file. I'm encountering an Error. The file size is 8MB so I think that may be the issue since I've previously used this formula with no problems, do I have any alternative routes to populate this…
Luis
  • 75
  • 1
  • 5
5
votes
1 answer

How to select rows in google sheets by condition

I've been researching this for a couple of hours now and have had no luck. I am trying to search for emails in my spreadsheet that contain "@google.com" and have them all selected so that I can copy them instead of going through them 1 by 1. There…
Ian Probets
  • 123
  • 1
  • 9
5
votes
2 answers

QUERY function with one result returns value beneath the formula cell

When I use the =QUERY function in Google Sheets, it returns the value in the cell beneath where I typed the function. I want the returned value to appear in the cell I typed the function. Currently, I have =QUERY(Data!$L:$N,"select avg(N) where L =…
John Doe
  • 121
  • 1
  • 3
  • 9
5
votes
4 answers

Google Sheet - Transform two columns into one column using arrayformula (more than 50,000 characters)

I'm using Google Sheets and looking for an arrayformula that able to take a list in two columns and arrange it alternately in one column. The sheet contains about 5,000 rows, each row has more than 35 characters. I tried…
Eli
  • 91
  • 2
  • 7
1
2
3
…
96 97