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 How to use conditional formatting in this case..

    See attached file. Regards Bosco

    Jun 25, 2017 at 1:22 AM
  2. Logit replied to the thread When run this macro it delete all data..

    Everything highlighted in BOLD is clearing data from a sheet or range. Check to make certain those areas you want to be cleared : Sub...

    Jun 24, 2017 at 11:32 PM
  3. AExcel replied to the thread How to use conditional formatting in this case..

    My apologies for that. Can you help on my problem, any help would be appreciated

    Jun 24, 2017 at 9:45 PM
  4. AExcel posted a new thread.

    How to use conditional formatting in this case.

    Hi, Can anyone help me with this Condition formatting question? I am not able to figure out the formulae that I should use. Thanks in...

    Forum: Ask an Excel Question

    Jun 24, 2017 at 8:22 PM
  5. Liam Birkett replied to the thread Automatic Row Height Adjustments.

    Fab! Many thanks - Have a great weekend!

    Jun 24, 2017 at 8:18 PM
  6. Andrew Quirl liked NARAYANK991's post in the thread NEED HELP WITH IF/THEN STATEMENT.

    Hi , See the attached file. Narayan

    Jun 24, 2017 at 6:19 PM
  7. Andrew Quirl replied to the thread NEED HELP WITH IF/THEN STATEMENT.

    UR AWESOME!

    Jun 24, 2017 at 6:19 PM
  8. Chief Ace attached a file to the thread Representing EMOJIs on Charts.

    Luke M and NARAYAN recommendation are both great. I'm not sure if this would help.

    Jun 24, 2017 at 6:17 PM
  9. NARAYANK991 liked bosco_yip's post in the thread Convert feet and inches to inches.

    The B2 formula can be further reduced to : =IFERROR(INT(TRIM(MID(SUBSTITUTE("x"&$A2,"x",REPT("...

    Jun 24, 2017 at 6:12 PM
  10. bosco_yip replied to the thread Convert feet and inches to inches.

    The B2 formula can be further reduced to : =IFERROR(INT(TRIM(MID(SUBSTITUTE("x"&$A2,"x",REPT("...

    Jun 24, 2017 at 5:37 PM
  11. vletm replied to the thread When run this macro it delete all data..

    As Tip: Use [ CODE ] & [ /CODE ] tags to embed your VBA Macros Upload a Sample File to get a quicker response

    Jun 24, 2017 at 4:48 PM
  12. AlanSidman replied to the thread Automatic Row Height Adjustments.

    Look at this link. You will need to enable Wrap first. https://stackoverflow.com/questions/12132726/row-height-autofit-doesnt-work

    Jun 24, 2017 at 4:29 PM
  13. febausa posted a new thread.

    When run this macro it delete all data.

    I used this macro for many months with no problem; I delete all data I reinsert new data then when I run the macro it delete all data...

    Forum: VBA Macros

    Jun 24, 2017 at 3:13 PM
  14. Chirag R Raval liked SirJB7's post in the thread Question about Chandoo example macro: Consolidate data from different excel files (VBA).

    Hi, Smallman! I have a bit of time too and I am going to write... Hope you don't care, do you? If so, sorry, I apologize, but I'll do it...

    Jun 24, 2017 at 2:41 PM
  15. Chirag R Raval liked NARAYANK991's post in the thread Question about Chandoo example macro: Consolidate data from different excel files (VBA).

    Hi , See this revised file. The header labels will have to be in row 1. Narayan

    Jun 24, 2017 at 2:38 PM
Loading...