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-arrayformula
Search options not deleted
user 297772
Use for questions about the use of the Google Sheets built-in function ARRAYFORMULA.
0
votes
Accepted
In Google Sheets, can you repeatedly autofill until next non-blank cell all at once? (previo...
Welcome Marcus!
Yes, this is the way. First go to File-Settings-Calculations tab and enable Iterative calculation.
Now in cell C2 write the formula: =ARRAYFORMULA(IF($A$2:$A="",$C$1:$C,$A$2:$A))
Copy …
- 896
1
vote
Iterating over two arrays and comparing each pair
Most likely, your difficulties are connected with the fact that "Conditional formatting Rules only work on the current Sheet. This is by design. So when you point to another Sheet it will not work."
J …
- 896
3
votes
Accepted
How to select range into a cell based on drop down selection
Select all cells of the Ingredients column from the Recipes sheet using the FILTER() function by the condition "the Meal column is exactly equal to the selected value in cell C4". Combine the filterin …
- 896
1
vote
How to structure a vlookup in an arrayformula to accept multiple columns?
Welcome!
It seems to me that you are completely unnecessarily complicating the task with additional checks using IF (). In fact, you only need one condition: whether a particular row in 'MHC System Ma …
- 896
0
votes
Add a constant number to google sheets query result
={"","email","";QUERY(B6:C,"select '" & TRIM($C$5) &"', B, C where C='cool' label '" & TRIM($C$5) &"' ''",0)}
This formula will literally do what is shown in your screenshot.
Update For second screen …
- 896
2
votes
Combine different sheets with importrange for dynamic data from google forms
Welcome!
Perhaps it is worth considering the possibility to execute a QUERY() for each IMPORTRANGE() separately and combine the results of these queries into a single array?
={QUERY(
IMPORTRANGE("s …
- 896
0
votes
Split, Flatten, and Repeat Cells in Certain Columns Within an Array Formula for Google Sheets
Welcome!
Let's try a not-so-long script instead of a long formula:
function SplitAndCombine(aSourceData,delimiter =",") {
var temp = [];
var ind = 0;
for (let i = 0; i < aSourceData.length; i++) …
- 896
1
vote
Accepted
How to use data validation based on 2D array or row and column of tickboxes in google sheets?
Welcome!
The values of cells with a checkbox are either TRUE or FALSE.
To return TRUE if at least one checkbox is selected, use the OR() function. And for the opposite effect, use the negation of the …
- 896