Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.21 seconds.

  1. 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. Re: Unique Code for Same Names Appearing in a Column

    You are welcome.
  3. 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. 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. 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. 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. 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. 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. 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. 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. Re: Format(1000, "##0.000E+00") not working to format as engineering type

    Sorry, I was not familiar with the Engineering format.

    I came across this article. Perhaps it will help:
    https://excelribbon.tips.net/T012874_Engineering_Calculations.html
  12. 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. 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. 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. 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. 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 =...
  17. 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. 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. Re: Return Characters After A String of Characters in Excel

    You are welcome.
    Glad I was able to help!
    :)
  20. 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. Re: Return Characters After A String of Characters in Excel

    Try this:

    =TRIM(RIGHT(SUBSTITUTE(A2,"~p~",REPT(" ",LEN(A2))),LEN(A2)))
  22. Replies
    11
    Views
    175

    Re: urgent - nested ifs

    Then try this version:

    =IF(B1="","Pass",IF(AND(B1<>"",C1<>"",D1=""),"Pass","Fail"))
  23. 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. Replies
    11
    Views
    175

    Re: urgent - nested ifs

    That seems to contradict one of your original conditions:


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


    <tbody>
    A Blank
    B Blank
    C Blank
  25. 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 2 3 4