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
3
votes
1 answer

Google Sheets Query Group By / First-N-Per-Group

I'm trying to find a simple solution for first-n-per-group. I have a table of data, first column dates and rest data. I want to group based around the date, as multiple entries per date are allowed. For the second column some numbers, but want the…
Jammo
  • 1,838
  • 4
  • 25
  • 39
3
votes
2 answers

aggregate results by week, month for graphing using sheets

Is there a way to convert daily values into weekly averages for charting? Sample source sheet --------------------------------------------------- | Data 1 | 1/1/2018 | 1/2/2018 | 1/3/2018 | etc...365 days…
Fernan
  • 67
  • 2
  • 7
3
votes
2 answers

Creating chart of only certain rows

Using Google Sheets, is there a way to create charts for only certain rows? I have created some reports, but when the source list is sorted differently the report breaks because of using the data source as 'SourceTab'!A2:X2. In the source tab I…
Fernan
  • 67
  • 2
  • 7
3
votes
1 answer

Google Sheets Query string to date

I have a Google spreadsheet of several thousand rows of data. Column BC contains a date in a string format, YYYYMMDD. I am using Google's query function to pull specific records from the main sheet into other tabs withing the same document, and as…
Brian Brock
  • 357
  • 2
  • 3
  • 18
3
votes
3 answers

Google Spreadsheet =query - ignore entities where cell is empty

my starting table looks similar to the following Person 1, 75 Person 2, 48 Person 3, Person 4, 82 Person 5, Person 6, 93 ... I now try to include in following query a "where" statement to exclude entities that have no numeric value. This is what…
Claus Maier
  • 95
  • 1
  • 2
  • 9
3
votes
1 answer

using a variable in searchFiles Google script

I have a third party program that pulls daily data into CSV files with the filename starting with the date it ran e.g. 17072017filename.csv I need a seperate spreadsheet that will take a date input from the user, which will then search through the…
Gramps
  • 35
  • 1
  • 5
3
votes
1 answer

Google Spreadsheet's Query function returns empty data with order by

Google Spreadsheet's Query function returns empty data with order by. Here is the Query that is working properly: =QUERY('OtherListName'!A1:C;"Select A, B, C";1) This query returns exactly what you'd expect: the contents of the range A1:C (which…
Ilya Chernov
  • 411
  • 7
  • 18
3
votes
2 answers

Select the difference between two times in QUERY

I have a sheet with three columns: Name (A), startTime (B), endTime (C), and have been trying to run a Google Sheets QUERY that will show the duration (endTime - startTime). The problem appears to be how the QUERY is recognizing the startTime and…
Nulpoints
  • 81
  • 1
  • 5
3
votes
2 answers

Copy cell from on sheet to another, if other cell in row matches values

What I want, is to copy a cell(s) from one sheet to another, only if another cell in the same row (different column) have/has a particular value(s) in Google Sheets. Ideally, I would like this to be live; if I add a row in the first sheet and the…
Jonathon Oates
  • 2,912
  • 3
  • 37
  • 60
3
votes
1 answer

How to use IFERROR inside an array formula?

If any of the queries in an array formula do not have actual data to query in the range they are hitting they return #VALUE! and mousing over the array formula reveals an error. If I take those queries and wrap them in an IFERROR I get the same…
Overlordchin
  • 185
  • 3
  • 3
  • 13
2
votes
1 answer

Drop down list to filter data using query

I am stuck with a sheet that I want to filter the data using drop down list. here is a sheet attached with two drop down list in the "DETAILS" tab were the data having same name with different category and result. So if I select a name from drop…
Iker666
  • 25
  • 1
  • 5
2
votes
1 answer

Query continues to select rows despite 'where not null'

I'm using a query command in google sheets to take the left variable of a text string, convert it to a number and sum it with other columns. When I attempt to use a query command of where Col1 is not null it continues to pull each row leaving a…
jhaff
  • 25
  • 4
2
votes
1 answer

Merging records from google sheets column

I am working on a Google sheet where I am using INDIRECT to get data from other tabs in the spreadsheet and list the unique ones followed by their frequencies. There are multiple columns now with pair of word, count from each tab in the…
CodeMonkey
  • 2,265
  • 9
  • 48
  • 94
2
votes
1 answer

What is the function for filtering data that is not in a list in google sheets?

I haven't made a spreadsheet with slightly more advanced formulas for over a year. I've been trying to do this for hours, searching the internet. But I haven't found anything that works as I need it. it should be simple, but I need help. I have 3…
user616324
  • 65
  • 1
  • 10
2
votes
1 answer

Get value from another google sheet

The formula should be placed in C7: ={"SCHEDULE";ARRAYFORMULA()} Need a formula that will search the name of the user from INDIRECT(J6) and find the Time from another sheet (1) depending on the Sched sheet name in cell B3 and (2) based on what day…
KB John
  • 89
  • 5
1 2 3
…
96 97