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 microsoft-excel
Search options answers only
not deleted
user 196152
Questions with this tag should ONLY be about how Microsoft Excel interacts with a specific web application. General questions about Microsoft Excel are off-topic here but can be asked at Super User.
1
vote
IF Statement works in Excel but not G Sheet?
The correct formula is:
=IF(G15=TRUE,1,0)
That is, drop the quotes around TRUE.
1
vote
How can I highlight the source cells in a formula (e.g. =SHEETA!$E$568 )
Try this script.
To access it, either put it in a custom menu or create a shortcut.
function jumpto() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var ui = SpreadsheetApp.getUi();
// creat …
- 5,841
1
vote
Accepted
Creating Hyperlinks of Google Drive Items in Alphabetic Order
An option is to output the file name as well as the HYPERLINK() function. This should allow you to:
sort the output,
lookup the file name and return hyperlink (or vice versa, according to your prefer …
- 5,841
1
vote
Automatically Color Series In Chart
The following answer was developed piecemeal and many elements could have been combined to create a more efficient process. However, each of the functions will run standalone and this may assist the O …
- 5,841
0
votes
Getting the latest date of something happening (with conditions)
Use this formula:
=MAX(IF(Sheet1!$A$2:$A$8=B2,IF(Sheet1!$B$2:$B$8=B3,Sheet1!$C$2:$C$8,0)))
where:
Cell B2 = the name of the person as listed in Sheet1
Cell B3 = the thing as listed in Sheet1
If the …
- 5,841
0
votes
How can I change the min and max value of vertical axis in chart?
Edit the chart
Select "Customize"
Select "Vertical Axis"
Where it says "Min" and "Max", enter the desired minimum and maximum axis
Close the Chart Editor
- 5,841
0
votes
Google Sheets - Multiple countifs
There are a number of ways to resolve your problem, and several precedents included in WebApps and StackOverflow. But, as is common, your data doesn't directly align with any of the examples, and this …
- 5,841