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 formulas
Search options not deleted
user 206167
Formulas used in spreadsheets edited by web applications like Excel Online, Google Sheets, among others.
0
votes
2
answers
6k
views
FILTER for multiple conditions including OR
How can I use FILTER in a single formula to check for multiple conditions, such as in this case?
The filtered range must be equals1 AND notequal2 AND equals3 OR equals4
This is of course an arbitrar …
- 55
1
vote
1
answer
461
views
How to stack ranges horizontally?
The 3 ranges may or may not differ in dimensions (different number of columns, which embedded arrays dislike) and I'm trying not to use 3 different formulas in different cells. …
- 55
0
votes
2
answers
682
views
ArrayFormula for consequential sum-up?
Here's a sample test spreadsheet - https://docs.google.com/spreadsheets/d/
What do I have to do in the ONE cell in column D such that I won't have to copy and paste the same formula in column C throu …
- 55
0
votes
2
answers
124
views
ArrayFormula for conditional consequential sum-up?
I have a table which looks like this:
And formula in cell B3: =IF(A3>5, B2, B2+1) and on every next row a corresponding variation of this formula.
I would like to know how to create ArrayFormula …
- 55
1
vote
2
answers
43
views
Perform operation on specific column in filtered range, right after filtering
I have this formula in E2: =FILTER(A1:C20,B1:B20=2) and need to perform substitute like:
spreadsheet here
I'm hoping to do the formula in a single cell, without additional columns.
- 55
2
votes
1
answer
28
views
What's the difference in using the internal formatting and using TEXT to format cells?
What's the difference in using the Formatting drop-down and using =text() to format cells? Which one overrides the other or take priority? It seems I'm having some formatting conflict that is breaking …
- 55