All Questions
29 questions
0
votes
2
answers
153
views
Prevent SPLIT from converting text to numbers in Google Sheets when used in an ARRAYFORMULA?
I have rows of data like so:
a|b|1|c|d
a|b|1, 2|c|d
e|f||g|h
I am using BYROW to split them:
=BYROW(
A2:A,
LAMBDA(
row,
SPLIT(
row,
"|",
...
- 5,893
1
vote
1
answer
552
views
How to avoid this empty row using QUERY() in Google Sheets?
I've tried applying some criteria, but the row is still there.
This first empty row shouldn't be there.
Here is the formula, in case you'd like to help me correct it:
=if(I4<>"", { ...
- 2,372
1
vote
2
answers
69
views
Showing Top 5 Clients at a dashboard
I want to build a dashboard where I can select a year and a application and want to have the top 5 clients shown up.
I build a example Sheet ofr showing:
https://docs.google.com/spreadsheets/d/...
- 59
1
vote
1
answer
506
views
Google Query Language: How to average multiple columns when each one has a different condition?
The data
I have a table as the following in Google Sheets:
Month
Country
Metric Name
Value
Nov
AAA
Metric_1
98
Nov
AAA
Metric_2
45
Nov
AAA
Metric_3
4
Nov
BBB
Metric_1
100
Nov
BBB
Metric_2
214
Nov
BBB
...
- 13
2
votes
1
answer
416
views
Google Sheets QUERY with WHERE on multiple columns at the same time
Following this post Google Sheets QUERY with WHERE on multiple columns I build up my formula to select specific values from more columns but when I had a condition data start to be confused and not ...
1
vote
2
answers
68
views
Filter Data in Googlesheets
I have to face some problem about my Googlesheets Data. I want to filter my googlesheets data between two dates and also filter more conditions at the same time in same sheets. Below are given some ...
0
votes
1
answer
294
views
Virtually blank column in array?
I use this formula in Google Sheets:
=SORT({SORT({'Discord-D'!B2:B, 'Discord-D'!A2:A,
ARRAYFORMULA(IF('Discord-D'!G2:G = "", "", IF('Discord-D'!C2:C <> "", "...
user19120926
1
vote
1
answer
70
views
Combining Query and Conditional Statement in Google Spreadsheets
Regardiung the function below, I want this line AND P < '"&B5&"' to be applied everytime but not when B3="446".
I'm not sure how to insert this condition in the query ...
- 159
1
vote
1
answer
76
views
Join column header with array n times
I am looking to join column headers with their respective arrays any number of times depending on if the cell is not empty and if it has a checkbox.
Link to sheet
I have a formula close but I can't ...
- 1,053
1
vote
1
answer
40
views
Survey completness problems in Google Sheets
I'm trying to have information about the completness in some survey results exported in to a Excel Format I'm using Google Sheets, as every survey there is questions and subquestions the subquestions ...
user16239103
1
vote
1
answer
818
views
Pick unique values from two non-adjacent columns
Please see the attached sample: https://docs.google.com/spreadsheets/d/1m625-WxG9VBv5AG-VR9-pf4bUCcG8AMCrb_z3jMYCqo/edit#gid=0
Columns A,B,D and E are my source columns. I want to pick unique values ...
- 33
0
votes
1
answer
7k
views
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 47 [duplicate]
When I am trying to use create this function. =QUERY(XXXXXXXXXX!$A$1:$CJ,"select BL,BM,BN,BK,BP,BQ,BR,BO,BT,BU,BV,BS,BX,BY,BZ,BW,CB,CC,CD,CA,CF,CG,CH,CE
where A > date '2022-03-21'") I ...
- 11
1
vote
1
answer
150
views
VLOOKUP: How do I match one column to another sheet and join them without losing data?
I have two sheets that look something like this:
Sheet1
id | phone | age
0 123 23
1 456 42
2 789 36
Sheet2
id | city | country
0 madrid spain
1 nyc usa
2 dubai uae
...
- 51
1
vote
1
answer
37
views
How to match with common cities visited in
The goal is to match the special and the normal and the condition is that they have a common city. The special's name should appear in Column E and the Normal's name should appear in Column F and they'...
user18587694
1
vote
1
answer
1k
views
How to merge these two queries into 1 Google Sheets
I m looking for a way to use these below two queries into 1 I have tried a lot but everytime got an error. I have searched as well on google but nothing find. your help will be appreciated
No .1
=...
- 537