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
Google sheets countif same date
You need COUNTIFS() instead COUNTIF()
=COUNTIFS(A2:A,">="&B2,A2:A,"<"&(B2+1))
- 896
1
vote
Accepted
Finding if a value exists in a cell containing comma separated text
SPLIT() combined with MATCH() will do the trick:
=IF(ISERROR(MATCH(<tested value>,SPLIT(<cell for testing>, ", " , 1,1),0)),FALSE(),TRUE())
- 896
0
votes
Accepted
Transposed sum of several columns?
In general, your task is formulated as follows:
apply the function to individual columns of a specific range and place the results vertically in consecutive cells in the column
Or the reverse problem: …
- 896
1
vote
Accepted
=RANK, but only show top 5 or top 10
Welcome!
Let's assume that your original list starts at cell A1 and contains two columns labeled Name and Rank. It is by the values from the second column that five (ten) best results should be select …
- 896
0
votes
Accepted
How to get COUNTIF to validate cell is unique properly in Google Spreadsheets?
Cell to compare (in your formula C2) must be address of first cell of formatted range (in your example with range Sheet1!C1:C8205 it is C1).
Please try =COUNTIF($C:$C,"="&C1) < 2
- 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
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
3
votes
How can I jump to a cell reference
For this your example, everything is simple: F2 to enter cell editing, Shift+Home to select the entire formula, Ctrl+C to copy it to the clipboard. Now Ctrl+J to go into editing the Name Box, Ctrl+V a …
- 896
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
1
vote
How do I search for a specific value in a row, and return the exact value of the cell two co...
Welcome!
The first step - finding the cell with Mary was done exactly right: it is the MATCH() function that does the job. The function will return either a number (cell number from the beginning of t …
- 896
0
votes
Google Sheet filling with minutes
I also believe that the use of the time functions TIME(), HOUR() and MINUTE() is correct - anyone who reads the formula sometime later will easily understand what the formula does.
However, your task …
- 896
0
votes
Accepted
How to pull multiple values based on date ranges
Welcome!
You are absolutely right - the FILTER() function solves this problem. The main difficulty is to formulate a double condition. This is where the trick comes in, just multiplying booleans (and …
- 896
0
votes
Accepted
Google Sheets: formula to match and find column header value if there is a tick/cell is not ...
For example from your screenshot just put to J5 =FILTER($C$4:$I$4,C5:I5<>"") and fill down
- 896
1
vote
Accepted
Multiple independent IF statements in one cell for multiple cells
Welcome!
You don't need an IF(), use the FILTER() function to select the headings you want, combine the selected words with the TEXTJOIN() function (use CHAR(10) to put each word on a new line), and w …
- 896
0
votes
Using a checkbox to show data in other cells
I hope this helps to understand the sequence of actions to solve your problem:
- 896