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
Search options not deleted
user 111648
For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.
3
votes
1
answer
335
views
How to turn a list of months string into a list of month numbers?
I have a table with month headers at the top:
January | February | March | ...
Is there a way with one formula that I can get a list of month numbers?
January | February | March | ...
--------+--- …
- 602
2
votes
2
answers
609
views
Create a list of categories from a 2D array
I have data like the following:
CategoryA SubA1 SubA2
CategoryB
CategoryC SubC1
...
I would like to avoid using scripts and hopefully only use one (albeit complex) formula to get an array like the …
- 602
33
votes
Accepted
How can I import a column from one sheet into another sheet of the same Google Sheets spread...
One way to do this is with ArrayFormula. If the sheet you want to import from is named Sheet1 and you want to select the entirety of column A, you can do the following:
=ArrayFormula('Sheet1'!A:A)
Yo …
- 602
10
votes
1
answer
26k
views
Remove header and blank row from the results of a SUM, GROUP BY query
I have a two column table where one column is some sort of key where duplicates are allowed and the other column includes amounts.
I then have the following formula somewhere else on the sheet:
=QUE …
- 602