# Search:

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

Page 1 of 6 1

1. ## Thread: If CountIf - Help Displaying Blank Cell

by Joe4
Replies
3
Views
127

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

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

by Joe4
Replies
3
Views
127

### 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...
3. ## Thread: Why the lag before Excel calculates?

by Joe4
Replies
3
Views
100

### 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...
4. ## Thread: VBA to search a column for the first instance of a date within a designated month

by Joe4
Replies
4
Views
46

### 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...
5. ## Thread: Sort by cities

by Joe4
Replies
4
Views
98

### Re: Sort by cities

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

by Joe4
Replies
3
Views
100

### 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...
7. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

### 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...
8. ## Thread: Sort by cities

by Joe4
Replies
4
Views
98

### 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...
9. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

### 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...
10. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

### 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....
11. ## Thread: Week numbers but in the same month only add up

by Joe4
Replies
2
Views
100

### 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...
12. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

### 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.
13. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

### 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...
14. ## Thread: Converting number to fixed length field

by Joe4
Replies
8
Views
471

### 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...
15. ## Thread: Converting number to fixed length field

by Joe4
Replies
8
Views
471

### Re: Converting number to fixed length field

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

by Joe4
Replies
1
Views
52

### 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.
...
17. ## Thread: Combine/Join 2 tables and get an output in 3rd table

by Joe4
Replies
7
Views
672

### 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],...
18. ## Thread: Combine/Join 2 tables and get an output in 3rd table

by Joe4
Replies
7
Views
672

### 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
54

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

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

by Joe4
Replies
2
Views
54

### 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:...
21. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

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

It is important to understand exactly what that part of the formula is doing:
TODAY()-D7
It is taking the past date in cell D7, and seeing how many days it is in the past from today.

If you do...
22. ## Thread: Conditional formatting highlight

by Joe4
Replies
9
Views
269

### Re: Conditional formatting highlight

Did you try locking down the references like I showed in the last post and see if that solves your issue?
23. ## Thread: IF x numbers of days have passed, do this.

by Joe4
Replies
17
Views
381

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

No, you do not need a helper column.
If your date is in column D, you could do a formula like:

=IF((TODAY()-D7)>=5,G7+H7,"")

by Joe4
Replies
4
Views
93

### Re: Count If

You are welcome.
25. ## Thread: excel 2002 convert numbers to mathematical

by Joe4
Replies
30
Views
804

### Re: excel 2002 convert numbers to mathematical

Are there really question marks and dollar signs in your text data?
If so, then you will need to remove those to make them actual numbers.
A simple Find/Replace can do that, or it can be done via...
Results 1 to 25 of 144
Page 1 of 6 1