# Search:

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

Page 1 of 6 1

1. ## Thread: SUMIF based upon worksheet name?

by Joe4
Replies
3
Views
62

### Re: SUMIF based upon worksheet name?

Let's say that you have a working SUMIF function like this that returns the correct value for Month for the name in cell B4 on the current sheet:

=SUMIF(May!A:A,B4,May!B:B)
Now, let's say that...
2. ## Thread: Unique Code for Same Names Appearing in a Column

by Joe4
Replies
5
Views
47

### Re: Unique Code for Same Names Appearing in a Column

You are welcome.
3. ## Thread: Unique Code for Same Names Appearing in a Column

by Joe4
Replies
5
Views
47

### Re: Unique Code for Same Names Appearing in a Column

Did not see the formula I provided above?
If you do not like having to place a 1 in the first cell only (E2), you could use this formula in all cells instead:

=IF(ROW()=2,1,IF(D2=D1,E1,E1+1))
4. ## Thread: Unique Code for Same Names Appearing in a Column

by Joe4
Replies
5
Views
47

### Re: Unique Code for Same Names Appearing in a Column

Assuming that this is going in column D, and the first line of data is row 2 (header in row 1), place a 1 in cell E2, and then place the following formula in cell E3 and copy down for all rows:
...
5. ## Thread: Format(1000, "##0.000E+00") not working to format as engineering type

by Joe4
Replies
9
Views
92

### Re: Format(1000, "##0.000E+00") not working to format as engineering type

Yeah, there are many Excel functions that don't appear in VBA, and then some that are similar that go by different names (i.e. the "Text" Excel function is similar to the "Format" VBA function).
And...
6. ## Thread: Format(1000, "##0.000E+00") not working to format as engineering type

by Joe4
Replies
9
Views
92

### Re: Format(1000, "##0.000E+00") not working to format as engineering type

If there is no digit to fill it because it is less than the value, it will pad fill it with a zero.

I believe that the issue you are having is there does not appear to be a way to tell the...
7. ## Thread: How to replace weekend and capture the next business day

by Joe4
Replies
3
Views
63

### Re: How to replace weekend and capture the next business day

That looks significantly different from your original post.

It does not matter what your date format is, as long as the entries are actually dates, and not text or numbers.
Can you confirm? An...
8. ## Thread: Simple Formula in Excel?

by Joe4
Replies
1
Views
50

### Re: Simple Formula in Excel?

Duplicate: https://www.mrexcel.com/forum/excel-questions/1107188-help-excel-formula-pulling-data-another-sheet.html

Please do not post the same question multiple times. All clarifications,...
9. ## Thread: Macro ActiveSheet.Formula Object doesn't support this property or method error

by Joe4
Replies
12
Views
64

### Re: Macro ActiveSheet.Formula Object doesn't support this property or method error

You are welcome.
And you learned a new little trick for getting VBA code! :)
10. ## Thread: Format(1000, "##0.000E+00") not working to format as engineering type

by Joe4
Replies
9
Views
92

### Re: Format(1000, "##0.000E+00") not working to format as engineering type

Excel functions and VBA functions are not the same, and do not always work the same.

I was looking through that article, and I could find that. I even did a search on "engineer" and it found no...
11. ## Thread: Format(1000, "##0.000E+00") not working to format as engineering type

by Joe4
Replies
9
Views
92

### Re: Format(1000, "##0.000E+00") not working to format as engineering type

Sorry, I was not familiar with the Engineering format.

https://excelribbon.tips.net/T012874_Engineering_Calculations.html
12. ## Thread: How to replace weekend and capture the next business day

by Joe4
Replies
3
Views
63

### Re: How to replace weekend and capture the next business day

For a date in cell A1, try this formula:

=IF(WEEKDAY(A1,11)<6,A1,WORKDAY(A1-1,1))
If the day in cell A1 is a weekday, it will return that day. Otherwise, it will return the following Monday.
13. ## Thread: Format(1000, "##0.000E+00") not working to format as engineering type

by Joe4
Replies
9
Views
92

### Re: Format(1000, "##0.000E+00") not working to format as engineering type

This works for me:

Debug.Print Format(1000,"0.000E+00")
14. ## Thread: Macro ActiveSheet.Formula Object doesn't support this property or method error

by Joe4
Replies
12
Views
64

### Re: Macro ActiveSheet.Formula Object doesn't support this property or method error

Things can get tricky when you are trying to add in a formula that has literal quote marks, as those are also used for Text delimiters in VBA. If you do not do it correctly, VBA cannot tell if you...
15. ## Thread: Macro ActiveSheet.Formula Object doesn't support this property or method error

by Joe4
Replies
12
Views
64

### Re: Macro ActiveSheet.Formula Object doesn't support this property or method error

You are still missing the range part, as I mentioned in my initial reply.
16. ## Thread: Macro ActiveSheet.Formula Object doesn't support this property or method error

by Joe4
Replies
12
Views
64

### Re: Macro ActiveSheet.Formula Object doesn't support this property or method error

You need to provide the range also. Otherwise, it does not know where on the Active Sheet you want the formula, i.e.

ActiveSheet.Range("A2").Formula =...

by Joe4
Replies
2
Views
187

### Re: Shared Excel Database Advice

Personally, I would use Access. If you split the database to have a single central back-end that holds all the data, and front-end that you share with users (each user has their own copy), then...
18. ## Thread: VBA - Format Rows containing word 'Total'

by Joe4
Replies
8
Views
249

### Re: VBA - Format Rows containing word 'Total'

Try this:

If the formatting piece isn't quite perfect (i.e. wrong color), you can turn on the Macro Recorder and record yourself setting the color you want. Then you can copy over the correct...
19. ## Thread: Return Characters After A String of Characters in Excel

by Joe4
Replies
3
Views
84

### Re: Return Characters After A String of Characters in Excel

You are welcome.
Glad I was able to help!
:)
20. ## Thread: VBA Clear Content based on certain value

by Joe4
Replies
3
Views
45

### Re: VBA Clear Content based on certain value

That is because your code is looking for a literal text string of "#Value" and not the "#Value" error.
You can use the ISERROR function to locate errors. See:...
21. ## Thread: Return Characters After A String of Characters in Excel

by Joe4
Replies
3
Views
84

### Re: Return Characters After A String of Characters in Excel

Try this:

=TRIM(RIGHT(SUBSTITUTE(A2,"~p~",REPT(" ",LEN(A2))),LEN(A2)))
22. ## Thread: urgent - nested ifs

by Joe4
Replies
11
Views
175

### Re: urgent - nested ifs

Then try this version:

=IF(B1="","Pass",IF(AND(B1<>"",C1<>"",D1=""),"Pass","Fail"))
23. ## Thread: urgent - nested ifs

by Joe4
Replies
11
Views
175

### Re: urgent - nested ifs

I was off a column in my grid, it is not A, B, C, but rather B, C, D. But I can now see what you are after.
Since there are only two conditions that would return "Fail", let's check for those, and...
24. ## Thread: urgent - nested ifs

by Joe4
Replies
11
Views
175

### Re: urgent - nested ifs

Listed below is all possibilities. Please fill in the missing result for each one:

<tbody>
A Blank
B Blank
C Blank
25. ## Thread: urgent - nested ifs

by Joe4
Replies
11
Views
175

### Re: urgent - nested ifs

You can use VBA if you want to, but it isn't really necessary here.
Results 1 to 25 of 150
Page 1 of 6 1