# Search:

Type: Posts; User: Joe4; Keyword(s):

Page 1 of 6 1

1. ## Thread: IF statement based on date

by Joe4
Replies
2
Views
44

### Re: IF statement based on date

Try:

=IF(YEAR(C9)=2019,F9+F10,0)

by Joe4
Replies
4
Views
39

### Re: #Value Error

I don't think it like setting numeric fields equal to "".
What if you try:

=IF(ISBLANK(C8),0,H7+F8-G8)
If that does not work, please tell us the contents of C8, H7, F8 and G8.
3. ## Thread: highlight cell according to date difference

by Joe4
Replies
1
Views
45

### Re: highlight cell according to date difference

So, do you only want it to check that as you enter the value in the cell (and not done the road, for values already entered in)?
If so, you can use VBA to do that.

Righ-click on the sheet tab...
4. ## Thread: Conditional formatting highlight

by Joe4
Replies
11
Views
327

### Re: Conditional formatting highlight

I don't know how much more able I will be able to help without seeing your workbook.
As I mentioned before, I cannot download files from my current location, but I can from my home.
So, if you are...
5. ## Thread: Code needed for Max & Min Values

by Joe4
Replies
36
Views
1,032

### Re: Code needed for Max & Min Values

Perhaps it will speed up some it you disable screen updates and calculations until the end of the code too:

Private Sub Worksheet_Calculate()

Dim cell As Range

' Exit if A1 not...
6. ## Thread: If CountIf - Help Displaying Blank Cell

by Joe4
Replies
3
Views
141

### Re: If CountIf - Help Displaying Blank Cell

You are welcome. Glad it works for you!
:)
7. ## Thread: If CountIf - Help Displaying Blank Cell

by Joe4
Replies
3
Views
141

### Re: If CountIf - Help Displaying Blank Cell

Is this what you are looking for?

=IF(COUNTBLANK('Document Request'!K10:K40)=31,"",IF(COUNTIF('Document Request'!K10:K40,"Outstanding")>0,"Outstanding",IF(COUNTIF('Document...
8. ## Thread: Why the lag before Excel calculates?

by Joe4
Replies
3
Views
103

### Re: Why the lag before Excel calculates?

I came across it some years ago (10+) when supporting someone who had workbooks of Excel files with 20-30 sheets of data, spanning dozens of columns and tens of thousands of rows, mostly with VLOOKUP...
9. ## Thread: VBA to search a column for the first instance of a date within a designated month

by Joe4
Replies
4
Views
47

### Re: VBA to search a column for the first instance of a date within a designated month

Are you just trying to get the SUM of a particular month?
If so, instead of doing something like that, why not use a SUMIF, SUMIFS, or SUMPRODUCT formula to sum all the records where your designated...
10. ## Thread: Sort by cities

by Joe4
Replies
4
Views
103

### Re: Sort by cities

You are welcome.
Glad we were able to help.
11. ## Thread: Why the lag before Excel calculates?

by Joe4
Replies
3
Views
103

### Re: Why the lag before Excel calculates?

Whoa! That is a lot of cells with calculations!

With Auto Calculation, Excel determines which cells need to be re-calculated when a change to the data is made. It does this by tracking...
12. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
388

### Re: IF x numbers of days have passed, do this.

Just knowledge of the different functions available and their capability (so experience, really). There aren't too many hard-and-fast rules regarding whether VBA is needed or not. Things like date...
13. ## Thread: Sort by cities

by Joe4
Replies
4
Views
103

### Re: Sort by cities

You don't even need to split the columns, just add a helper column with the following formula (for an entry in cell A2):

=MID(A2,FIND("(",A2),LEN(A2))
You can then sort by the helper column (and...
14. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
388

### Re: IF x numbers of days have passed, do this.

You are welcome. The keys are the ROW and MOD functions.

ROW() will return the row number of whatever cell the formula is placed in.
To see this, you can simply enter =ROW() in any cell and see...
15. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
388

### Re: IF x numbers of days have passed, do this.

LOOKUP will return whatever is found in the cell, be it a number, text, or date.
OFFSET is a range function.

Regarding your question, a few questions about it, that may make this really easy....
16. ## Thread: Week numbers but in the same month only add up

by Joe4
Replies
2
Views
111

### Re: Week numbers but in the same month only add up

Where are the values you are adding up, and where are you putting these SUMs?
How are you currently getting the SUM? With a SUMIF or SUMIFS formula?
If so, you should able to do what you want with...
17. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
388

### Re: IF x numbers of days have passed, do this.

If I understand your question correctly, then I do not think that link is doing the same thing that you want, so I don't think you will be able to adopt those methods.
18. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
388

### Re: IF x numbers of days have passed, do this.

Excel can either have a formula, or a hard-coded value in a cell, and one cannot turn to the other without it being done manually, or by VBA.
So I think you answer requires VBA. You would need...
19. ## Thread: Converting number to fixed length field

by Joe4
Replies
8
Views
1,123

### Re: Converting number to fixed length field

Mike,

If the entry is truly a numeric entry (maybe with formatting to show decimals):

Then your code wouldn't work in this case:

Now, if 10152.00 was entered as Text, then it would work...
20. ## Thread: Converting number to fixed length field

by Joe4
Replies
8
Views
1,123

### Re: Converting number to fixed length field

I think you are overcomplicating this unnecessarily.
21. ## Thread: Excel Issue between dates (specific month)

by Joe4
Replies
1
Views
63

### Re: Excel Issue between dates (specific month)

Assuming that your dates are in cells A1 and A2, and A2 is always after A1, this formula will return a "Yes" if any August date falls in the range, and a "No" if it does not.
...
22. ## Thread: Combine/Join 2 tables and get an output in 3rd table

by Joe4
Replies
7
Views
750

### Re: Combine/Join 2 tables and get an output in 3rd table

Sorry, we need to remove the JOIN part too, and add the other table to the FROM clause, i.e.

SELECT (A.[First Name]+' '+A.[Last Name]) AS [Employee Name], A.[Person Number], A.[Work Email],...
23. ## Thread: Combine/Join 2 tables and get an output in 3rd table

by Joe4
Replies
7
Views
750

### Re: Combine/Join 2 tables and get an output in 3rd table

Is "Cost Center" in Table B a Text/String or Numeric field?
If numeric, try this:

WHERE MID(A.[Cost Center],4,8)=B.[Cost Center]
if "Cost...

by Joe4
Replies
4
Views
62

### Re: VBA Change Entire Columns with specific header to Value instead of Formulas

You are welcome.
Glad I was able to help!
:)
25. ## Thread: Combining multiple cells into one

by Joe4
Replies
2
Views
61

### Re: Combining multiple cells into one

Welcome to the Board!

What version of Excel are you using? If you are using Excel 2016 or newer, I think this can be done easily with the TEXTJOIN function (see:...
Results 1 to 25 of 150
Page 1 of 6 1