• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Luke M

  1. Luke M

    Fetching data from notepad to excel

    I'm glad you were able to get your question solved. Please note that in the future, you should post links to any cross-posts you create(d). https://eileenslounge.com/viewtopic.php?f=30&t=34629&start=20
  2. Luke M


    Please follow all forum rules, including remaining civil to one another. It does appear that multiple threads have been created with very similar topics. For now, I'll give benefit of doubt. To OP, I would suggest starting a new thread and clearly asking for help with whatever part you are...
  3. Luke M


    I'm not 100% sure what you mean in condition #2, but try this: =SUMPRODUCT((E5:E23<10000)*ISNUMBER(SEARCH({"Int","Chg"},D5:D23))*(RIGHT(E5:E23,1)<>0)*E5:E23)
  4. Luke M

    IF Formula Closing Bracket is a issue for me

    Administrative Note: Welcome to the forum. We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here. Note: As you are new I...
  5. Luke M

    Conflicts between Dim, ReDim and Split

    @BobBridges Welcome to the forum. In the future, please remember to include links to your cross-post. Most online forums (including ours) have rules about this. https://www.msofficeforums.com/excel-programming/44721-conflict-between-dim-redim-split.html You're new, so just posting this as a...
  6. Luke M

    Extract Specific Data out of a .txt file by VBA

    @pda8 Please start your own thread for a question, rather than appending (hijacking) and existing thread.
  7. Luke M

    Set trial period

    Try clearing out the Named Range 'ExpirationDate'. Might have an old one in there that's messing you up.
  8. Luke M

    Set trial period

    Cleaned up code: Sure thing. Private Const C_NUM_DAYS_UNTIL_EXPIRATION = 1 / 144 Sub TimeBombWithDefinedName() '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' TimeBombWithDefinedName ' This procedure uses a defined name to store this workbook's ' expiration...
  9. Luke M

    Vba Code Vlookup And Sumif Super Fast

    Per forum rules, pleae remember to include links to cross-posts http://www.vbaexpress.com/forum/showthread.php?66912-I-need-VBA-code
  10. Luke M

    solver problem - need help

    Cross-posted (and solved) https://www.chegg.com/homework-help/questions-and-answers/please-assignment-excel-using-solver-submit-excel-file-thapar-theatre-company-needs-determ-q44621047?trackid=59fb658e0014&strackid=ddf507c21609
  11. Luke M

    INDEX/MATCH question

    Closed this thread due to duplication.
  12. Luke M

    INDEX/MATCH question

    Assuming that you would multiply each percentage against the other (so apples-north gets 100% then formula in B17 =SUMPRODUCT(G$2:G$11,INDEX($B$2:$E$11,,MATCH($A17,$B$1:$E$1,0))) Copy across and down to D20
  13. Luke M

    macros for vlookup in dynamic range with two worksheets

    Change the one line of code from this "=VLOOKUP(A2,'" & sourceSheet.Name & "'!$A$2:$B$" & SourceLastRow & ",2,0)" to this "=IFERROR(VLOOKUP(A2,'" & sourceSheet.Name & "'!$A$2:$B$" & SourceLastRow & ",2,0), 0)"
  14. Luke M

    Extract Multiple Rows into a Limited Template based on Multiple Criterias

    Please include links to your (many) cross-posts. Simply spamming a request across all forums w/o letting the respective members know is considered rude.
  15. Luke M

    Automatic Goal Seek

    @Mark Carver Please take a moment to review our forum Rules & Guidelines, specifically about cross-posting. Thanks. https://www.excelforum.com/excel-general/1297531-automate-goal-seek.html