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
2
votes
2 answers

Google sheets plot frequency per day in a chart

I am trying to plot frequency per day from a column in a chart. The column has entries for multiple dates of month and may have multiple entries per day. I want to plot those in a chart . Using X-axis as the date. I have explored multiple options…
CodeMonkey
  • 2,265
  • 9
  • 48
  • 94
2
votes
3 answers

How to count unique or the last occurrence of duplicate values based on another column?

I've attached an example below. I have a large sheet similar to Raw Data table from the image. My goal is to count unique occurrences based on the first column (ID) of the Results table. In the Raw Data table, the ID consists of the main ID and its…
MiaD229
  • 33
  • 3
2
votes
2 answers

How can I create a range display from a list of non consecutive numbers?

I made a bash script to display numbers in range and I wonder if it's possible to do the same in Sheets without scripting. I got in a column (let's say A) a list of numbers, for example : 001 002 004 012 013 014 ... and I have a variable prefix in…
To Piquette
  • 23
  • 4
2
votes
2 answers

Google Sheets: SUM multiple numbers in same CELL based on Word

I want to calculate SUM how many items sold, the sold items are encased in brackets, example: 1st Product Title [ 1 ] (for this product 1st Product Title the customer buy only 1 item so how can SUM quantity sold for each product even if there are…
James
  • 172
  • 1
  • 1
  • 13
2
votes
1 answer

Sum across many rows with transposed formulas google sheets

I'm trying to build a formula that will count the total number of classes happening within a date range. This is the formula I can use, but it needs to include hundreds of rows (i.e. 'Class Counts' from B2 until B500 or so). Is there any way to turn…
Brian - RGY Studio
  • 386
  • 1
  • 8
2
votes
1 answer

Check for cells containing strings with non-latin letter characters in Googlesheets using Regex with QUERY

I'm currently working with a database in Googlesheets containing app publishers linked to financial apps. I plan to match it with another list that has multiple bank names from multiple countries. The problem is that the first database has the names…
Daniel Díaz
  • 39
  • 3
2
votes
1 answer

Breaking down lists of words

I have a Google spreadsheet with 2 columns and thousands of rows. Every line consists of a unique ID (ex: 123) for the first column, and a list of words for the second, like this: "hello","example","love" 123 | "hello","example","love" How to make…
kpeirt
  • 107
  • 1
  • 1
  • 6
2
votes
1 answer

Concatenate cell values if they have a similar value in another cell

I need to concatenate the city names that a person has been to into another cell but they have to be repeated every time the name of the person comes up. I tried using COUNTIF but couldn't get me anywhere. I don't wanna use VB code; just…
Iman Ghavamabadi
  • 47
  • 6
2
votes
2 answers

Counting the number of occurrences in a cell every nth row in Google Sheet

=countif('Sheet2'!$K$6,$AD25)+countif('Sheet2'!$K$13,$AD25)+countif('Sheet2'!$K$20,$AD25) +countif('Sheet2'!$K$27,$AD25)+countif('Sheet2'!$K$34,$AD25)+countif('Sheet2'!$K$41,$AD25) …
aiorr
  • 547
  • 4
  • 11
2
votes
1 answer

Dynamic date function in Google sheets - how to implement it?

I was wondering if you could help me with a google sheets formula for the following issue: I am trying to use a dynamic date formula so that I could extract all the letters from column B that appear in the last 40 days to a different tab in the…
MM91
  • 23
  • 4
2
votes
2 answers

How to list the most frequent 3-word strings on Google Sheets

I have a list of industries with a adjacent list of industries to categorize them. I would like to know which industries are the most common but I don't manage to make Sheets interpret two-word categories as one. First, I would like to know which 5…
djur
  • 304
  • 2
  • 13
2
votes
1 answer

How can I get text from a cell using the select statement of the query function in Google Sheets?

I try to get some data from tab A to tab B using the query function. This all works fine untill I include some data of tab B into the object in the query function. The thing is, I want to create a scoring sheet that calculates the constructor points…
Danny Hoekstra
  • 53
  • 1
  • 8
2
votes
2 answers

Union multiple ranges in google sheets with programmatic lookup

I have a google sheet with a dynamically changing number of worksheets within it. I'd like to be able to automatically union all worksheets that included in a named range that has the worksheet names. I have a manual formula that is working and will…
Neil
  • 5,179
  • 8
  • 48
  • 87
2
votes
3 answers

Any way to create a copy of my document of Google Sheets with query-importrange function without returns a message error?

I've made a query function with importrange function on Google Sheets. The problem is when I try to make a copy of that document for share then in the copied file returns "No_Column: Col2". I've no idea how to solve this issue. =QUERY( {…
Héctor Ruíz
  • 35
  • 3
2
votes
1 answer

Offset column 2 of query results by one row

I'm trying to create a list of results from a QUERY where the result from column 1 acts as a "title" in column 1 and then the result from column 2 would be displayed on the following row, but still in the second column. And this would be the…
TC76
  • 860
  • 1
  • 8
  • 17
1 2 3
…
96 97