Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with google-sheets-query
Search options not deleted
user 190024
Use for questions about QUERY built-in function from Google Sheets.
0
votes
Query based on column header in Google Sheets
I created a sample sheet from your data, with a few more columns.
Basically, I took raw data, and added another row immediately underneath the date header. This new row contains =JOIN(";",A4:A9), and …
- 366
3
votes
1
answer
6k
views
Query returning results into merged cells in Google Sheets
Short Question:
I have a query function returning an array over merged cells. Instead of displaying all of the values in the array, some of the data is hidden in merged cells where only the first i …
- 366
1
vote
2
answers
70
views
Confirm that values in a column are alternating
I have a column, call it A, of around 1500 cells. Each cell contains either "a" or "b". For the most part, the As and Bs are alternating, but sometimes there are repeating values.
An example of A1:A2 …
- 366