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. bosco_yip attached a file to the thread This month Last month in excel.

    Maybe............ 1] Setup a "List Table" for Day/Week/Month in N1:N10 2] Data Validation in D5 >> Allow: List >> Source: =$N$2:$N$10...

    May 23, 2018 at 1:25 PM
  2. paneliyadhruv replied to the thread Excel VBA repeat numerical series based on value in another cell or variable.

    Sir, First 1 to 5 is column D output in yellow. While second two times (1 to 5) is column E output.

    May 23, 2018 at 12:56 PM
  3. Asheesh attached a file to the thread Excel VBA repeat numerical series based on value in another cell or variable.

    Why is series 12345 populated thrice in range AB15:AB29, See image below Shouldn't this be 1 repeated 5 times then.. [ATTACH]

    upload_2018-5-23_17-18-18.png May 23, 2018 at 12:48 PM
  4. dparteka liked Haz's post in the thread Third Level Formula Does Not Update.

    That's the normal behavior, WS-03 will return the value saved in WS-02 without recalculating it.

    May 23, 2018 at 12:41 PM
  5. dparteka liked Luke M's post in the thread Third Level Formula Does Not Update.

    The three are working for me. Verify that you had all 3 worksheets open in same instance of XL?

    May 23, 2018 at 12:41 PM
  6. dparteka replied to the thread Third Level Formula Does Not Update.

    Luke M... the problem is I have another workbook that is looking for the updated value in WS-03 which would not be opened… but as Haz has...

    May 23, 2018 at 12:41 PM
  7. anshul.malhotra attached a file to the thread Overlapping time calculation.

    Please find the enclosed file with data which is populated, though at a given point of time no tech is handling 3 overlapping task. I...

    Graph.png May 23, 2018 at 12:24 PM
  8. Svmaxcel replied to the thread This month Last month in excel.

    Excellent Buddy this worked well however in this i have to select c5 & d5 both. can we combine it as in, D5 should have option like Today,...

    May 23, 2018 at 12:17 PM
  9. paneliyadhruv replied to the thread Excel VBA repeat numerical series based on value in another cell or variable.

    No Sir, Result is like AB column output. A to Z columns remain unchanged.

    May 23, 2018 at 12:11 PM
  10. Asheesh attached a file to the thread Excel VBA repeat numerical series based on value in another cell or variable.

    First, welcome to the forum Should the result be something like the attached image.. [ATTACH]

    upload_2018-5-23_16-29-30.png May 23, 2018 at 11:59 AM
  11. Asheesh attached a file to the thread How to convert year based multi line data in single line for each customer?.

    Another solution using formulae. Follow the below steps: Copy data from Column A to Column J of “Original” worksheet and paste it on new...

    May 23, 2018 at 11:51 AM
  12. vletm attached a file to the thread How to convert year based multi line data in single line for each customer?.

    Chirag R Raval Try to Press [ Do It ]-button in cell D1.

    May 23, 2018 at 11:40 AM
  13. paneliyadhruv posted a new thread.

    Excel VBA repeat numerical series based on value in another cell or variable

    Dear All, First of all thank you very much. Kindly help me on below problem. I have 1 to 50 number in column A and from columns B to Z...

    Forum: VBA Macros

    May 23, 2018 at 11:11 AM
  14. Belleke replied to the thread Match login details to cells in file.

    Thanks for the feedback:) Suc6

    May 23, 2018 at 10:58 AM
  15. JeroenCreemers replied to the thread Match login details to cells in file.

    TOP, super bedankt.

    May 23, 2018 at 10:54 AM
Loading...