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
5
votes
3 answers

Google Sheets - query contains array

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 Where A "is in the selected array of names" What would…
Asaf Nevo
  • 11,338
  • 23
  • 79
  • 154
4
votes
2 answers

How to add and highlight rows on input of particular column in Google Sheet

In the attached google sheet. Google Sheet - https://docs.google.com/spreadsheets/d/1KxqaI-GYWur0Knt_bShI0GURucqU_cawu_sCoG_8Xlc/edit?usp=sharing I need to execute the following two operations on input. Add same number of rows against which ID if…
Sophia Wilson
  • 581
  • 3
  • 16
4
votes
1 answer

How to add extra text to Query results?

I have a sheet with data that a Google Form is continually adding data to. Once the data is added, there is a subset that I need to have sectioned off to another sheet. I'm transposing the data so it sorts vertically for each Form's data, and the…
confuseddesk
  • 85
  • 2
  • 10
4
votes
2 answers

Sum column only of rows that match a condition (of another column)

I have a spreadsheet in Google with the following data: **Status Amount** Under Review $120.00 Delivered $50.00 Paid $320.00 Paid $110.00 Under Review $200.00 I want to sum all the column Amount, only but…
Jorge GVD
  • 43
  • 3
4
votes
3 answers

Extracting and counting unique word frequency from a range

I have a column where each row is a sentence. For example: COLUMN1 R1: -Do you think they'll come, sir? R2: -Oh they'll come, they'll come all right. R3: Here. Stamp those and mail them. R4: It's ringing. R5: Would you walk Myron the other…
Shian Han
  • 307
  • 1
  • 5
  • 16
4
votes
2 answers

List unique values in 1 column and concatenate corresponding values in other column

Column C should contain the unique values from column A, and in column D it should combine the corresponding values in column B as shown in the attached example. Ideally using a formula with QUERY or ARRAYFORMULA (so not having to drag down the…
dean2020
  • 645
  • 2
  • 8
  • 25
4
votes
1 answer

Create Weekly/Monthly/Yearly line chart in Google Sheets to sum amounts within same week/month/year range

I want to create a line graph representing two columns of data: F, the date of entry, and H, the dollar amount. The date should be the X-axis, and the dollar amounts on the Y-axis. The catch is that I'd like the dates on the line graph to represent…
thecyclist
  • 65
  • 2
  • 6
4
votes
3 answers

Google Sheets - Number of days since the last date a range of cells

I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column. If 2 columns have 2…
Harry Norman
  • 185
  • 13
4
votes
3 answers

Mix data of multiple columns into one column

I want to combine the content of three columns into one column like in this example: Col1 Col2 Col3 A 1 x B 2 Y So the result is a column with 8 lines like this: Result A 1 X A 1 Y A 2 X A 2 Y B 1 X B 1 Y B 2 X B 2 Y I need a…
Mario Andrés
  • 107
  • 1
  • 8
4
votes
1 answer

Merge multiple tables

I have lots of sheets describing different kind of expenses and gains of my small company, and I find no easy way to merge my tables like in this example I made: I want the last table to be auto filled with the lines of the others tables when I…
Ty Kayn
  • 719
  • 7
  • 24
4
votes
2 answers

Search whole spreadsheet to find text within a cell and then print the whole row

I have a Google Sheets that contains several rows and columns of data and would like to search for a certain phrase in each row of the spreadsheet and then print the row out on a new sheet if that row contains the phrase in one of the columns of…
user1464409
  • 1,032
  • 5
  • 18
  • 31
3
votes
1 answer

How to use importhtml in Google Sheets to import tables from multiple URLS coninuously in same spreadsheet?

URL1, URL2, URL3 all contain one table each. I am currently importing each in different sheets. Is there anyway to import them continuously in the same spreadsheet? Update1: The number of rows in tables vary everyday, so I have to do it manually. I…
Nix
  • 153
  • 1
  • 12
3
votes
1 answer

Iterate over a comma-separated list in a Google Sheets Cell

I'm working on a Google Sheet and want to automate the process of turning the columns into a custom JSON object. I have one column in my sheet that is a comma-separated list of strings: "apple", "orange", "banana" and I want to create an Array…
nathan lachenmyer
  • 5,298
  • 8
  • 36
  • 57
3
votes
3 answers

Count occurrences of a specific word in Google Spreadsheet

I have some cells with text. I need to count the occurrences of a specific word (not a list) from those cells. Example sheet:https://docs.google.com/spreadsheets/d/1WECDbepLtZNwNfUmjxfKlCbLJgjyUBB72yvWDMzDBB0/edit?usp=sharing So far I found one way…
JOY
  • 399
  • 3
  • 15
3
votes
1 answer

Applying formula to visible cells only (using filters) on Google Sheets

Brief: I am using a formula to retrieve the information relative to the most frequently used words in a list. I am trying to make it work together with a filter in order to narrow down the results. Parallel to this, I am filtering the results of a…
djur
  • 304
  • 2
  • 13
1 2
3
…
96 97