In Google Sheets, how do I get the value of the first non-empty cell in the row 17 starting at column C forwards?

I have a range with a name column. I also have a list of names chosen be presented. I want to run a query which will select data from this range only if it names is inside this list: Select C Wh...

I'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But it returns a little table with "sum" as header and result below it. What I want is just...

I've seen some examples of using SUM() inside an ARRAYFORMULA() in Google Spreadsheets (and oddly enough, they all seem like workarounds) but I can't figure out how to apply them to using MIN() ins...

I'm having trouble figuring out a fairly simple QUERY statement in Google Spreadsheets. I'm trying to use a cell reference instead of static values and I'm running into trouble. Below it the code I...

I have a query like this =QUERY(B2:C9; "select (C * 100 / B) - 100") in my Google Sheets. What is displayed as a column header is: difference(quotient(product(100.0()))100.0()). I want to put a h...

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...

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?...

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 trie...

While removing the header row in a Google sheets query function seems straightforward, I don't see any suggestions on removing the header row when the query involves a pivot. For reference, I am gi...

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 resu...

update My original question was about taking the average of a single column of a named range. But upon reflection, the question generalizes to "how do I extract a single column from a named ra...

I am trying to piece together a query that does a few things. One, I want it to list out all the names in a column, and two, I only want it to list out the name from that column if it doesn't exist...

I working on making a report based on data from 19 other Google Sheets. I'm using QUERY but I'm kinda new to this and not sure if I'm doing it right or not. I'm trying to use below but it seems so...

As you can see from my picture, I have a list of bowling scores and some running averages. The issue I cannot seem to solve is I would like to be able to see the change in average between a game ...

I have a Google Sheet with the following query formula: =QUERY('Contact Changes'!B1:T,"SELECT C,D,E,F,G,H,I,J,K,L,M,N,O,R,S WHERE T='RMT'") The source sheet displays the following results ...

I want to import a range from another Google sheet, but to ignore empty cells so that the data prints back to back (versus having big gaps created from importing empty cells). Here is my formula (G...

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 Col1...

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 co...

I'm working with one Spreadsheet named "geral" (General, in Portuguese), where I saved all informations and the column A saves the Names of the people. I created another sheet just to see some colu...

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!$...

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 a QUERY formula that imports the first three rows of some data, "Select Col1, Col2 Order by Col2 desc limit 3", producing an output like this: | c1 | c2 r1 | Red | 53 r2 | Blue | 45 r3 | Y...

In Google Sheets, What do I do if I want a cell to display the row number in which a certain word/line of text appears? So, I'm working with two kinds of spreadsheets here: One has the number of "...

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 col...