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. Shailender replied to the thread Every Month totals.

    Hello, Xcelthug, the code is working. Thank you for your response.

    Mar 24, 2017 at 8:03 PM
  2. Rohit Tiwari posted a new thread.

    (RT) - DATE MACRO - AGE CALCULATION

    Hi, I need a macro/vba code which can calculate the Age calculation. I mean it must calculate current date minus the different pay date in...

    Forum: Ask an Excel Question

    Mar 24, 2017 at 7:26 PM
  3. marilyn attached a file to the thread bar chart with duration of an event against time of day.

    wow, this is amazing. I wish I knew how to do this - I have been traveling so my apologies for not responding sooner. I will need to show...

    Mar 24, 2017 at 7:19 PM
  4. Charter liked Chihiro's post in the thread Power Pivot time aggregation & charting ?.

    Hmm, try changing Hour column formula to =TIME(HOUR([TIMESTAMP]),0,0) And then enable multi-level category labels. Unfortunately I can't...

    Mar 24, 2017 at 7:17 PM
  5. Charter replied to the thread Power Pivot time aggregation & charting ?.

    Thanks Chihiro, I will continue to look too - hopefully between us......

    Mar 24, 2017 at 7:17 PM
  6. Charter liked Marc L's post in the thread Advice on simple gap filling Macro?.

    At medium level, instead of copying row by row this new demonstration works with consecutive empty rows block : Sub Demo2() Dim Rg...

    Mar 24, 2017 at 7:15 PM
  7. Charter replied to the thread Advice on simple gap filling Macro?.

    Thanks Marc, I will take it for a sping and try to learn how it works - have a good weekend.

    Mar 24, 2017 at 7:15 PM
  8. Khalid NGO replied to the thread Pulling List of Data, based off of Drop Down Selection.

    Hi AFox, Good Day... Check this {array formula} in Input Sheet D4 and copy down:...

    Mar 24, 2017 at 7:14 PM
  9. XcelThug attached a file to the thread Every Month totals.

    HI There, This code is lengthy but it will work. In sheet2 , enter the first date of Feb and autofill it down so as to get all the first...

    Mar 24, 2017 at 6:10 PM
  10. Chihiro replied to the thread About Power BI.

    ... .gov or .org related mail id ... That's not true. I used my google business's email account and had no issue. Just note that it asks...

    Mar 24, 2017 at 5:52 PM
  11. Chihiro replied to the thread Power Pivot time aggregation & charting ?.

    Hmm... let me test it out over the weekend.

    Mar 24, 2017 at 5:36 PM
  12. cbon liked Chihiro's post in the thread Data from Different ScoreSheet.

    First uninstall PowerQuery. Then repair Office installation and make sure all updates are applied. Then reinstall PowerQuery. If the issue...

    Mar 24, 2017 at 5:29 PM
  13. cbon liked Chihiro's post in the thread Data from Different ScoreSheet.

    Here you go. IMPORTANT: Keep master file in separate folder than source files. Step by step explanation 1. First added "Import" sheet to...

    upload_2017-3-15_12-26-39.png Mar 24, 2017 at 5:29 PM
  14. cbon liked PCosta87's post in the thread Pulling List of Data, based off of Drop Down Selection.

    Hi, Attached... A combination of INDEX/SMALL/IF in array form should do it. Copy down as necessary. Hope this helps.

    Mar 24, 2017 at 5:08 PM
  15. Derek McGill liked bosco_yip's post in the thread Need Macro to Split First Name Last Name Middle Name Surname.

    Try..... 1] In "First Name" E2, formula copy down :...

    Mar 24, 2017 at 5:00 PM
Loading...