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 297772
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.
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
2
votes
Accepted
Is it possible to do a more concise IF x = 1 OR x = 2 OR x = 3 in Google Sheets?
Since the result of MOD(ROW(),7) can have 2 inappropriate values (0 and 1) and 5 suitable values (2..6), it makes sense to check the condition for a shorter sequence:
MOD(ROW(),7)>1
In this case, ther …
- 896
0
votes
Formula that combines name and true/false into a third column
This is just one of many possible ways:
=ArrayFormula(TEXTJOIN(", ",1,if(D3:D10,A3:A10,"")))
1
vote
How to divide the values of a table in google slides by a number using App Script?
Welcome!
I dare to suggest that you don't really need to really divide numbers by a million - you need to display the contents of the cells as if they were reduced by a million times. Try using the fo …
- 896
2
votes
Accepted
Trying to round a number to the nearest millions
It is enough to correctly specify the places parameter in the ROUND(value, [places]) function.
In this case, all the patterns you provided contain eight zeros, so the places parameter should be -8:
=R …
- 896
1
vote
Count occurences
I don’t know if this option would be easier, but for me the formula
=SUM(ARRAYFORMULA(IF($E$4:$J$9=$A4,N($E$3:$J$3=B$3),0)))
placed in cell B4 and then stretched over the entire range B4:D9 gave the s …
- 896
2
votes
Accepted
How do I activate and use "drag cell's corner" Google Sheets feature from keyboard?
Yes, you can select the desired range using only the keyboard - use the keyboard shortcut Ctrl+J, enter the desired range and press Enter.
Here is a sequence of steps that simulates drag-by-corner fr …
- 647
1
vote
Accepted
Add values in a row based on the date values in a sepperate row
Welcome!
One of the easiest solutions is to put in cell I6 the formula =SUMIF(C2:I2,"<=" &TODAY(),C4:I4) and repeat this for every week
- 896
0
votes
Accepted
Why is Google Sheets unable to apply conditional formatting to multiple cells of different r...
Welcome!
The formula you provided evaluates correctly for cell D17 because it is the first cell in the specified formatting range.
But for E18 the condition will change to =COUNTIF(M6,0), for F19 to = …
- 896
0
votes
Filter function outputting results differently depending on greater or less than
Welcome!
Please try
=FILTER(J2:J21, (J2:J21<=101)*(J2:J21>0))
or =FILTER(J2:J21, (J2:J21<=101)*(J2:J21<>""))
(empty cells are less than 101, right?)
- 896
1
vote
sheets query requires splitting last returned column by comma
It's not entirely clear why you insist on using QUERY().
Perhaps
=ArrayFormula({OFFSET(named-range,0,0,,2),SPLIT(OFFSET(named-range,0,2,,1),",")})
will do the job?
Finally, you can query the result of …
- 896
1
vote
Accepted
Managing poll answer in a spreadsheet: grouping same questions
Welcome!
Such a table transformation is not very complicated, it can be done with three simple formulas.
Put the formula ={"User ID";UNIQUE(A2:A)} in cell E1 and you will get a column with the IDs of …
- 896
1
vote
Google sheet Conditional formatting if text is in a list of words
If each cell contains only one word, and not a phrase with the specified word, then you can use
=MATCH($F1,{"this", "is", "a", "set", "of", "words"},0)
- 896
1
vote
How to use a specific formula in every row in a specific column now and in the future in goo...
In order for the formula to calculate a value for each element of the specified arrays, you must specify that you mean exactly arrays. The special function ARRAYFORMULA() is used for this.
To suppres …
- 896
0
votes
In Google Sheets, how can I enter several if then criteria, then return the actual value of ...
There are several ways to implement logic based on multiple comparisons. For example, if values are defined for each of the possible options, then you can use this trick using the CHOOSE() function
Se …
- 896