• 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

    Hui...

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

Search results

  1. Luke M

    Adding XL version

    @Hui Any luck on finding the setting to display this information and let it be seen by others?
  2. Luke M

    Adding XL version

    Thanks Hui. I see under Preferences where we can enable something, but like the others I don't see that info being displayed anywhere.
  3. Luke M

    Adding XL version

    Status update: Sadly, I've not been able to get a hold of Chandoo or anyone who can actually implement the change to the forums. Continuing to try and reach out. Maybe they're on travel? :(
  4. Luke M

    Adding XL version

    Thanks for the info, this helps!
  5. Luke M

    Adding XL version

    Sorry pecoflyer, but I have been researching and trying to see if that's an option with our current platform. I can see and we've discussed porting to a different forum platform, but so far that is being considered a larger undertaking than we want to do for just a "quality of life" improvement...
  6. Luke M

    Adding XL version

    Hello everyone. Sorry for not seeing this until today; long weekend for me. I agree that conveying what version of Excel someone is using is a key piece of information. With the current forum tools available, there's certainly nothing stopping us from including that info in a signature. You...
  7. Luke M

    Balance Amount Continue

    Formula in H6 should be =H5+G6 and then copy that down.
  8. Luke M

    Nesting formula help!

    Rather than trying to understand your method, what's the goal? To check if value in col A is the first letter of col B? =AND(A2<>"",LEFT(B2)=A2)
  9. Luke M

    Number formatting does not seem to work

    After review, this question is a follow-up to previous; not a duplicate. Thread re-opened.
  10. Luke M

    Calculation speed of formula

    Appears to be duplicate/similar to: Improve spreadsheet design | Chandoo.org Excel Forums - Become Awesome in Excel
  11. Luke M

    Changing the values from Indian Rupees to Dollars with correct spacing

    @KSKwin This thread is 8 years old. I suggest starting your own new thread where it will have more visibility.
  12. Luke M

    Send email (with VBA) and update "status"

    Sorry about that. Marc is correct, remove the leading period.
  13. Luke M

    Send email (with VBA) and update "status"

    Edit: Typo Sub SendEmails() Dim lastRow As Long Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim i As Long Set OutApp = CreateObject("Outlook.Application") 'How much data is there? lastRow = Cells(Rows.Count, "A").End(xlUp).Row...
  14. Luke M

    XIRR

    @grcshekar You have cross-posted again to another forum w/o providing links: XIRR modification to ignore some columns (excelforum.com) As you've already been previously warned in this thread about this, and continued to break the rules, this thread will be closed. Please remember to follow...
  15. Luke M

    If cell contains text, replace it with a specific value

    Formula you can put in P2, copied across and down. =IF(ISNUMBER(SEARCH(P$1,$O2)),P$1,"")
  16. Luke M

    why offset formula displays '0'

    Address and MATCH function tell the formula to look in G9. Then you told it to offset 2 rows in the first OFFSET function, landing you on G11. Then you told the outer OFFSET to go down 1 row and over 2 columns, landing you in I12, which is a blank cell. Thus, the value is 0. Overall, this is a...
  17. Luke M

    Scatter Chart with Dots displaying Spreadsheet Contents

    Please do not hijack other user's threads. If you have a question, you can start a new thread.
  18. Luke M

    Graph

    I'm not sure what you mean. If you have all the literal numbers on the chart, then you didn't need a chart. Could just do a data table.
  19. Luke M

    Graph

    Calculate duration, and then do a stacked bar chart using Start time and duration. Format the Start time series so that the duration bars appear to be floating. With your example data, I'm assuming Branch was supposed to go from 11 am to 1 pm (you had till 1 am). The processes don't appear to...
  20. Luke M

    Timeline - Extraction of Selection Label in a cell

    Rather than tacking on to an old thread, you'll get better luck by posting a new thread. As this is an old thread, I am closing it.
  21. Luke M

    looking up multiple values based on date and category

    Per forum rules, remember to include you crosspost links: https://www.excelforum.com/excel-formulas-and-functions/1378105-looking-up-multiple-values-based-on-date-and-category.html#post5675517 https://www.mrexcel.com/board/thread...egory.1205058/
  22. Luke M

    Automated filling of subsequent sheets based on condition

    Hi Pasadu, If there's a specific forum member you'd wish to donate to, several have links in their signature, or the Excel Ninjas (volunteer forum mods) have links here: https://chandoo.org/forum/threads/donate-support-our-ninjas.18150/ If you wish to support Chandoo directly, his contact info...
  23. Luke M

    A challenge for someone much smarter than myself (Please Help!)

    Rather than hijacking a thread (especially an old thread) it would be better to start your own new thread where others will be more likely to see it.
Back
Top