All Questions
Tagged with google-query-language sorting
42 questions
2
votes
2
answers
448
views
Copy/pasting query in Google Sheets between cells with automatic replacement of values
I have this query in my sheet:
=query(A2:A100, "Order by A Desc Limit 20")
I want to copy and paste it to more cells and expect it will update range and column from A2:A100 to B2:B100, C2:...
- 581
2
votes
3
answers
1k
views
group by and select row with the max date, and select all columns
I have the following data in a sheet.
event_id
event_type
event_name
date_col
123
critical_event
Event A
2021/12/16
456
critical_event
Event B
2021/12/25
999
medium_event
Event C
2021/12/13
888
...
- 41
1
vote
2
answers
61
views
List non-unique entries and their counts sorted in descending order
If I have a list of names in a sheet for example:
First Name|Last Name|Something else|
Maria|Miller|...|
John|Doe|...|
Maria|Smith|...|
Marc|Meier|...|
Marc|Park|...|
Maria|Muster|...|
Selene|Mills|......
- 397
1
vote
1
answer
85
views
Append the results of to 'Unique' formulas and order by date in google sheets
I have two Goole Sheet queries which both work as required my remaining challenge is to combine the results of both and order by date. my two queries are:
=UNIQUE(FILTER({'My Data'!B13:B, 'My Data'!...
- 1,149
1
vote
1
answer
74
views
ARRAY_LITERAL Error using 3 QUERY with month and year [duplicate]
I'm trying to use a google sheet formula to import data from 3 differente sheets using query with month and year. I used to use the query only with month and it works fine...I add "...and year(...
0
votes
2
answers
107
views
Sort by Date range asc
I need some quick and simple help with a query.
=query('Active Workstreams [update me] 10.2'!B6:L306, "SELECT B,C,D,I,J,L where C > date '"&TEXT(A8,"yyyy-mm-dd")&"' ...
- 1
-1
votes
1
answer
58
views
Wrong sorting while using Query function
I've been trying to do a report about the quantity of breakdonws of products in our company. The problem is that the QUERY function is operating as normal, but the sorting order is well - a bit ...
1
vote
1
answer
799
views
Google Sheet Query SUM exclude all SUM equal zero
cracking brain for this.
I have a very simple query with group and sum, and I want to exclude all sum results that are zero.
My actual query is:
=query(A:J;"SELECT D, SUM(I), SUM(H) WHERE C<&...
-3
votes
1
answer
87
views
Query Dates by Min Max of Percentage
I have two columns. Column A contains 3 dates. Column B contains 3 percentage values. What is the formula then to find the date for the highest vs. the date for the lowest percentage?
- 17
1
vote
1
answer
1k
views
Sort function in Query in Google Sheets
In google sheets, I want to sort a query function based on the date in my data. The date is in column V. I replaced my function with
"Select Q, R, S, T, U, V, W where 1=1 ORDER BY V asc"
to
=...
- 11
1
vote
1
answer
325
views
Google Sheets - Find and match value with filter
I have try using query, vlookup and filter to get data from other tab sheets
I don't know how to get data with logic condition.
Here my sheets :
https://docs.google.com/spreadsheets/d/...
- 329
1
vote
1
answer
119
views
Google Sheets Using Results from one query to return results in another (Nest or Join)
I've created a spreadsheet to track my trades using data exported from my brokerage. my spreadsheet has the following simplified format:
Date
Time
Symbol
Quantity
Amount
Starting Balance
Ending ...
- 637
1
vote
1
answer
89
views
Google Sheets =Query Function to Sort and not read formulated cells
I am looking to sort this data by Col1 and I have try so many ways and keep getting an error. Basically I am pulling data from all these tabs and giving me values based off the value in the dropdown ...
user19495375
2
votes
1
answer
135
views
How to run nested/subquery in google sheet?
SQl : select id,tod,count from new_temp where (id,count) in (select id,min(count) from new_temp group by id);
i want to run this in google sheet. How i can run this ?
[
- 47
2
votes
2
answers
1k
views
How to get max values for each unique value in a different column in Google Sheets?
I have two columns, the first column (A) has names and the second column (B) has values.
A
B
apple
10
orange
12
orange
14
apple
8
Is there a way to get only rows with unique names from A AND max ...
- 85