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

Automatically ranking data in spreadsheet by date

I'm currently using Google Sheets and want to find a way automatically to rank by date the data that I put in. I have two sheets: one in which I book a job at a particular post code and the date that they're expecting someone to arrive (all new…
user2062207
  • 955
  • 4
  • 18
  • 34
0
votes
2 answers

IMPORTRANGE to import multiple Google Sheets into one vertical column?

I am having a bit of an issue using IMPORTRANGE in Google Sheets to import multiple sheets into a single column on a master sheet and whenever one of the sheets is updated, it automatically creates the new row on the master. Would there be a better…
user5045801
0
votes
2 answers

How to QUERY a Spreadsheet by Row value

I Have a table in my spreadsheet like this FEB MAR APR MAY 10 14 7 13 12 9 8 19 15 11 14 16 And I want to use this info in another table. What I want to accomplish is in this another table compare two months by getting…
Felipe
  • 35
  • 4
0
votes
3 answers

Understanding "select X where Y = ..." in a google sheets QUERY function

I'm trying to figure out how to parse this google sheets function: =IFERROR(QUERY($A$2:$F$1000, "select F where A="&A4&" "),"") I'm having trouble understanding the "select F where A="&A4&" part. The function is applied to an entire column. For…
ioannes
  • 73
  • 1
  • 9
0
votes
1 answer

Querying an imported range works until I add any condition

Here's a QUERY that works: =QUERY(IMPORTRANGE("[key omitted]", "'FORM RESPONSES 1'!A1:G999"), "Select Col1, Col2, Col3, Col4, Col5, Col6, Col7", 1) This is just the same, but I added a "where" and a condition: =QUERY(IMPORTRANGE("[key…
user2031082
  • 63
  • 7
0
votes
1 answer

Transposing items with prices to separate section

In Google Sheets I'm trying to to transpose a list of items and their prices (displayed in rows) to automatically display in an adjacent section as columns. The problem is I need to only include the items which have prices. This demonstrates what…
Geoff
  • 21
  • 1
  • 7
0
votes
2 answers

SUM, FILTER, QUERY and IMPORTRANGE and match to data

On a separate spreadsheet I have project names in column 2 (B2:B). In column 10 (J2:J) of that same spreadsheet I have time (duration) spent on that project. These projects are repeated and additional time spent on them so they show up multiple…
user2748807
  • 89
  • 3
  • 12
0
votes
1 answer

How can I sort the output from a query that includes an array formula?

I have a formula that queries two sheets in the document and pulls data to a third sheet. If I add new data to the first sheet after the query has completed and then go back to the third sheet (with the query results) the new data is not at the…
Overlordchin
  • 185
  • 3
  • 3
  • 13
0
votes
2 answers

Google Spreadsheets Convert Matrix data into Relational rows

My Google spreadsheet data is in a matrix form with "holes". See https://docs.google.com/spreadsheet/ccc?key=0Ati5T34RP9mEdGJfcUFzVDV4elZIbExkTGM4aktQT2c&usp=drive_web#gid=0 I'd like to create another sheet from the above data to look like what I've…
RudyF
  • 805
  • 1
  • 10
  • 16
0
votes
1 answer

google_spreadsheet: query from another spreadsheet

I'm trying to run this command =QUERY( ImportRange( "1GPxWbG1B8WWXWgam-qJXstDCZ_TB0btQwTxwt9iaa8A" , "C_Detailed" ) , "select B where A = '"&Sheet3!$A$2&"'") But I get an Error: Unable to parse query string for Function QUERY parameter 2: …
Gck
  • 15
  • 1
  • 5
0
votes
1 answer

How to display part of information loaded with IMPORTXML function?

Here is my formula inserted in A1: =importxml("http://www.goldforex.be/servlet/javaparser?pgm=lst_or_new&lg=fr","//tr[@valign='TOP']") If you test this formula it will return numerous information. I would like to know how to display only…
seb mat
  • 3
  • 2
0
votes
1 answer

Finding the last seven days in a time series

I have a spreadsheet with column A which holds a timestamp and updates daily. Column B holds a value. Like the following: +--------------------+---------+ | 11/24/2012 1:14:21 | $487.20 | | 11/25/2012 1:14:03 | $487.20 | | 11/26/2012 1:14:14 |…
JordanBelf
  • 3,208
  • 9
  • 47
  • 80
0
votes
2 answers

Having problems with dates and times

I am having a few problems with dates and times in Google Sheets. What I have is: Spreadsheet 1 has a number of sheets one of which is called Sessions. On that sheet there are a number of columns which show all sorts of data about individual…
MikeE
  • 3
  • 1
  • 3
-1
votes
1 answer

To identify same words in two tabs in a google sheet

My Query is i want to highlight the duplicates in the two tabs in a sheet. My sheet is attached along with this question. In that "Sheet A" & "Sheet B" have common names in it i want to color it for the duplicates. Sheet :…
Iker666
  • 25
  • 1
  • 5
-1
votes
1 answer

Importing tasks from multiple sheets into one sheet

I would be happy to get the help of the experts here… Please check this spreadsheet: https://docs.google.com/spreadsheets/d/1pyog50iENw2p7X6g301gtLdh9TkWzCvvDa8-E-gQrqM/edit Our company deals with buyers and sellers of eCommerce businesses. For each…
Omri
  • 7
  • 1
1 2 3
…
96 97