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 not deleted
user 426758
A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
1
vote
IF statement that changes based on met condition
If I understand you properly, this is simply called "nesting."
An IF statement in Excel is =IF(TRUE,DO IF TRUE, DO IF FALSE) and so you simply insert another full IF statement as one of the branches. …
- 5,061
2
votes
Accepted
Odd behavior of texts from software
If I paste a number from one cell into another cell and then set the cell formatting to "text"; then use a pre-formatted-as-text cell to manually type the number; and then use your comparison, I get t …
- 5,061
0
votes
Excel FIND Error
your formula assumes that there is a "." and has no facility for the case when there is no "." Look at iif(expr, truepart, falsepart). Use find() in the expression to first determine if the field cont …
- 5,061
0
votes
Accepted
Conditional format formula IF/AND
Use an AND clause. The syntax would be:
=IF(AND(Something is True, Something else is True), Value if True, Value if False)
Manual: https://support.microsoft.com/en-us/office/using-if-with-and-or-and-n …
- 5,061
1
vote
Accepted
Why Are Columns Used for a Single Category of Data?
The top table is presentation the bottom table is data.
The convention for uniform columns is to ensure data is not polluted by commentary or irrelevant information and/or white space that will need …
- 5,061
0
votes
Count the number of incidents that overlap only no other incidents, 1 other incident, or 2 i...
The next step would be to take what you have in column E and aggregate it. So add a cell for "no other incident" and use =COUNTIF(E,"=1")
- 5,061
2
votes
run time error 13 VBA
Target isn't declared anywhere in your posted code (it might be a globally declared variable), and you probably do not have Option Explicit enabled. Enabling Option Explicit is a good idea generally a …
- 5,061
2
votes
Accepted
For Excel, what does the keyboard shortcut "SP" mean?
You would press S and then P in sequence.
- 5,061
0
votes
Excel VBA - Use string variable as input to Union Method
So S is a string and even though it reads as if it is specifying a Range, Union() requires a Range object, which is why you are getting a type mismatch error. You are passing the wrong type.
So as lo …
- 5,061
4
votes
Accepted
VBA "like" does not what it is supposed to do
If your data has anything after the colon, then you will need an additional * for it to test true. ( *intern*:* )
The regex sort of defaults to assuming you want leading and trailing wildcards. Regul …
- 5,061
0
votes
Error subtracting times
This is because the result is negative.
If the start time is greater than the end time, add 12 to the end time before subtracting:
=IF(A1>B2,(B2+12)-A1,B2-A1)
Note that your method of tracking (wit …
- 5,061
2
votes
Nested IF statement only working when outside IF changes
I am guessing wildly here, but I expect that you are calling this code from an Event fired on c27 only, so if you edit j57, the function/sub is not called.
- 5,061
0
votes
Carriage return location after scanning data
You can add an event handler to the workbook.
Alt+f11, double-click "ThisWorkbook" from the project tree, and put code such as this:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim …
- 5,061
2
votes
How do I get past size limitations in converting and MDB File
Excel is probably truncating memo fields to 256 characters. You need to open the MDB with software that supports memo fields: Access or perhaps Open Office Base if you don't have Access.
Open Office …
- 5,061
0
votes
Can my unwieldy SUMIFS VBA code be streamlined?
What I think you are doing is a primary loop on branch name (I'd probably use branchnumber); then looping on a town code (Irondeqouit; Henrietta etc.). The destination column is tied in some way to th …
- 5,061