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 297772
Formulas used in spreadsheets edited by web applications like Excel Online, Google Sheets, among others.
1
vote
Google Sheets Filter Lines with no Empty Colums - AT LEASTS ONE conlum filled
However, I do not advise you to look towards MMULT(), SEQUENCE() and others - formulas using them are difficult to understand, apply and edit. …
- 896
0
votes
Which Google sheets formula?
Welcome!
Try this:
={"Value","Cell(s)";
SORT(UNIQUE(FLATTEN(A1:E20))),
ArrayFormula(MAP(SORT(UNIQUE(FLATTEN(A1:E20))),
LAMBDA(unival,TEXTJOIN(";",1,
IF(unival=A1:E$20,
ADDRESS(R …
- 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,"")))
- 896
0
votes
count the number of unique records within date range
To get the number of unique values, you can first use a filter to select the desired rows by condition
=FILTER(A2:A, B2:B <= $F$6, C2:C > $F$6+1)
(You wrote that the date being checked is in A6 - I th …
- 896
0
votes
Find totals for each category based on categorization
Use a Pivot Table - this tool is designed to solve just such tasks
- 896
1
vote
Rotating Shift by Week
Welcome!
Let's solve this problem together step by step.
First of all, create a list of employees.
The shift schedule will be placed in a rectangular table.
Get something like this
Let's say we renum …
- 896
1
vote
Formula for subtotal based on a field
You don't need a formula! Everything you need to solve your problem is in the menu Insert - Pivot Table.
- 896
0
votes
Accepted
In Google Sheets how can I write a sequence with static words in front and a static number i...
Welcome!
If you need exactly the value, the string "hummingbird 12/100", then a formula like
="hummingbird " & (ROW()-2) & "/100"
(In this case, 2 is the row number before the start of the list)
If y …
- 896
2
votes
Is there such a formula as IF/AND/OR in Google Sheets?
Indeed, as already shown, two nested IF() functions solve your problem (See the Nested_Outcome formula in the Examples section)
I want to show another way of calculating for combined conditions, witho …
- 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
1
vote
Accepted
How to search a range for a matching word within a string?
Judging by the description, your data is presented in this way:
A
B
1
The dog had black spots all over
Keywords
2
well
3
over
4
steps
5
him
6
didn't
7
dog
8
that
9
all …
- 896
0
votes
Number of Days Positive and Negative Between Two Dates?
The results you described in your question can be obtained with a formula like this:
=B2-A2-(B2<A2)
- 896
0
votes
Need help coming up with formula to count and concatenate specific things
Welcome!
Please try
=IF(A2="","",A2 & TEXTJOIN(";",1," (n=" & IFERROR(MATCH("*",A3:A,0),1),OFFSET(A2,0,1,IFERROR(MATCH("*",A3:A,0),1),1)) & ")")
- 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