1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

  1. Hans Öjes replied to the thread Backwards planning with a schedule.

    Sorry, I missed that this finishtime was at a weekend. My misstake, it works fine within shop hours

    Oct 21, 2017 at 4:32 PM
  2. Hans Öjes replied to the thread Backwards planning with a schedule.

    Sorry, missed that. My misstake, it works fine within shop hours

    Oct 21, 2017 at 4:31 PM
  3. p45cal replied to the thread Backwards planning with a schedule.

    You are right vletm. What a fool I've been! (talking of 'the real world', I wonder how many copies of Excel Microsoft would have sold if,...

    Oct 21, 2017 at 4:28 PM
  4. Thomas Kuriakose liked NARAYANK991's post in the thread Calculate Overlapping Time in Excel.

    Hi , I am attaching a file which can only help partially ; all I have done is extend your formula to cover the various tests for...

    Oct 21, 2017 at 4:21 PM
  5. Thomas Kuriakose liked Haseeb A's post in the thread Formula Challenge 003 - Count unique characters common to two strings.

    Hello Challengers, Here is another CSE compatible with all versions....

    Oct 21, 2017 at 4:20 PM
  6. Thomas Kuriakose liked NARAYANK991's post in the thread Count the same number of characters between two cells in Excel.

    Hi , This might be helpful : https://chandoo.org/forum/threads/formula-challenge-003-count-unique-characters-common-to-two-strings.10898/...

    Oct 21, 2017 at 4:19 PM
  7. Thomas Kuriakose liked Naresh Yadav's post in the thread Count the same number of characters between two cells in Excel.

    Hi, Pls check if this works for you =COUNT(INDEX(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),B1),,)) regards Naresh

    Oct 21, 2017 at 4:19 PM
  8. Thomas Kuriakose liked Hui's post in the thread Hours Schedule by Role.

    P45Cal You might also want to have a read of...

    Oct 21, 2017 at 4:19 PM
  9. Thomas Kuriakose liked p45cal's post in the thread Hours Schedule by Role.

    Hui, what an interesting solution! Up until now, I have never explored What-if analysis in Excel. Its something I will dig into now though....

    upload_2017-10-21_11-50-49.png upload_2017-10-21_11-54-33.png upload_2017-10-21_11-58-38.png Oct 21, 2017 at 4:18 PM
  10. Thomas Kuriakose liked Hui's post in the thread Hours Schedule by Role.

    Let me see if this explanation helps you 1. The Goal ws is a Data Table It uses the Left column as the Input to the Data tables Column...

    Oct 21, 2017 at 4:18 PM
  11. Thomas Kuriakose liked Hui's post in the thread Hours Schedule by Role.

    This workbook links the HoursCostDistribution (2) worksheet to the HoursCostDistribution worksheet using a Data Table to pass each value...

    Oct 21, 2017 at 4:18 PM
  12. vletm replied to the thread Backwards planning with a schedule.

    Hans Öjes Just 'nice to know' ... Your Planned finishtime(date) is Saturday ... What kind of functionality have 'shop open - closes' times?

    Oct 21, 2017 at 4:11 PM
  13. shrivallabha replied to the thread hyperlink and other.

    First button will do just that as explained before. Read my response above in post #29-part 1.

    Oct 21, 2017 at 3:52 PM
  14. Hans Öjes replied to the thread Backwards planning with a schedule.

    Hi. I found a missmatch between P45cal & Narayan's model Finish 2017-11-04 09:00 runtime 19:30 open 07:00 close 16:45 Result: Narayan...

    Oct 21, 2017 at 3:48 PM
  15. vletm replied to the thread Backwards planning with a schedule.

    p45cal Okay, I see ... You know that it is totally wrong, but still You want to do it! hmm... You also waited that someone would notice...

    Oct 21, 2017 at 3:47 PM
Loading...