All Questions
Tagged with google-query-language spreadsheet
33 questions
0
votes
1
answer
654
views
Google Sheets - Query Function - Search Using Named Range
I'm making a sheet where I fill in my expenses for each month. I have a tab setup with several columns listed as 'Groceries' or 'Travel' (for example) that are my Named Ranges:
Groceries
Travel
Tesco
...
- 3
1
vote
1
answer
60
views
How to apply array formula to join all the cells in a column and exclude empty cells in google sheets doc spreadsheet
=ArrayFormula(join(",",char(34)&E3:E11&char(34))) This is the formula I have thus far.
It is able to output the values from the ranges I have manually chosen E3 to E11 which are
...
- 29
1
vote
1
answer
518
views
Label Column with Query that references multiple sheets in Google Sheets
using the below script to "append" data from multiple sheets on to one and it works but I need for it to add the sheet name where the data comes from in Column 28 and when I add label Col28 '...
- 63
1
vote
1
answer
28
views
How can I format a string sheet to date with Query
I have a col on googlesheet, that I need convert to date time with query function.
Column A
Column B
nome1
2022-11-17T13:41:47.431Z
name2
2022-11-17T13:41:47.431Z
Column A
Column B
nome1
2022-11-17 13:...
1
vote
1
answer
4k
views
Google Sheets: How can I return an array of all values from a column that have a certain corresponding value in another column?
I need (and have had difficulty arriving at) a formulaic way to produce the values shown in columns D, E, and F.
- 3,921
0
votes
2
answers
186
views
Google Sheets Bucket Monthly Country Data (QUERY?)
I have a Google Sheets spreadsheet of monthly data showing percentages by country. There are a few countries and EU that we are trying to highlight, along with grouping the rest of the countries as &...
- 11
1
vote
1
answer
135
views
Automatically Combine Duplicate Value and Rank
In Google Sheets, I am trying to rank a table of people to find out who contributes the highest numbers.
Sometimes one person contributes multiple times so I need to sum them up before ranking.
The ...
- 57
1
vote
1
answer
926
views
Google sheets bar chart with multiple variables
I am trying to create a google sheets bar chart showing instances/count of categories/variables (A,B or C) per year.
I’ve managed to create the following:
A - chart showing count/instances of the ...
- 13
1
vote
1
answer
110
views
How to use query to generate the result with descending order
Hi I would like to generate the result with descending order.
is it possible to use Query achieve this result? or is there alternative way ?
Thank you
https://docs.google.com/spreadsheets/d/1hnFi-...
- 201
0
votes
3
answers
502
views
Stack Google Sheets columns in a cleaner way?
I am making a spreadsheet to compare various lists in various different ways. One of those ways is to take a bunch of separate lists (each in different columns) and combine them into one large column (...
- 3
1
vote
1
answer
4k
views
How to simplify "IS NOT NULL" for multiple columns when using QUERY function in Google Sheets?
I have this formula:
=QUERY(
{AG4:AW101},
"Select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col15, Col16, Col17
where Col1 is not null
...
- 555
1
vote
1
answer
152
views
Reading a cell text as a Formula
I want excel (and google spreadsheets) to read a text as a formula.
Cell A1: 1+2
Cell A2: =readAsFormula(A1)
So cell A2 should show 3.
Can`t find any way to do it, and I wanted to avoid making a ...
1
vote
1
answer
86
views
How to generate a monthly report using 1 formula at A2
I am trying to build a monthly report. How can I write 1 formula at A2 to show Monthly Expense Summary.
I want months to show in a descending order. (May April March February January)
Thanks ...
- 201
1
vote
1
answer
303
views
Datetime comparison query
I have an importrange array to get data from alot of sheets. I organise zhem into one list and then make calculations from this list.
WORKBOOK
https://docs.google.com/spreadsheets/d/...
- 27
1
vote
1
answer
56
views
Function to organise a table
I have a table which I would like to make more dynamic based on values in two ranges.
I have a first table - DATE - (one column containing 1st January 2021 - 31st December 2022)
I have a second table -...
- 27