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. vletm attached a file to the thread Graph Visualisation Challenge 2017.

    Something same [ATTACH]

    Screen Shot 2017-04-27 at 10.03.37.png Apr 27, 2017 at 8:05 AM
  2. NARAYANK991 replied to the thread conditional formatting formula to modify.

    Hi , I am sorry but I am finding it difficult to understand what your requirement is. I have now understood the following : You have...

    Apr 27, 2017 at 7:43 AM
  3. vletm replied to the thread Counting how many occurences with multiple columns..

    change =COUNTIFS(Table1[ColumnA],"WH",Table1[ColumnB]:Table1[ColumnC],">0") to...

    Apr 27, 2017 at 7:33 AM
  4. Derek McGill liked SirJB7's post in the thread How to get the last used row number.

    Hi, vaios! Option Explicit Public Function lLastRow(Optional pvColumn As Variant) As Long ' constants Const ksADefault = "A" '...

    Apr 27, 2017 at 7:10 AM
  5. Derek McGill liked NARAYANK991's post in the thread Sub Worksheet_Change Question.

    Hi Paul , See if this works : Sub Worksheet_Change(ByVal Target As Range) Dim E As Object, F As Variant, j As Long, lr1 As String...

    Apr 27, 2017 at 7:02 AM
  6. Thomas Kuriakose liked SirJB7's post in the thread How to disable Checkboxes if one is checked and when unchecked enable them again?.

    Hi, Lizzz! Maybe I misunderstood your requirement. Let's start again. Check Boxes allow to enable more than one at the same time, while...

    Apr 27, 2017 at 6:57 AM
  7. sathishsusa replied to the thread conditional formatting formula to modify.

    sir, leave type i have three selection in column E Annual leave = 1 in-lue leave = 4 sick leave =5 if employee they select the leave...

    Apr 27, 2017 at 6:50 AM
  8. Thomas Kuriakose liked Luke M's post in the thread Remove password.

    Don't run the macro from the VBE, but from the workbook. As instructions state on the worksheet in file, you need to open the file you want...

    Apr 27, 2017 at 6:49 AM
  9. Chirag R Raval replied to the thread Require to save separate file in fix path for each unique subtotalled instance via inputbox.

    Dear Sir, This is final requirement (Final part) of whole this thread.... if we can full fill this requirement whole process cleared &...

    Apr 27, 2017 at 6:45 AM
  10. Abdulrahman7 replied to the thread Count No Of sessions(report).

    Good morning PCosta your idea is working as I wish, instead of changing the formula in a cell, will resize the table that's awesome but, I...

    Apr 27, 2017 at 6:35 AM
  11. Abdulrahman7 liked PCosta87's post in the thread Count No Of sessions(report).

    Hi, Instead of using simple ranges, try using a Table in the "Training List" sheet and then use the field names in the formulas. See...

    Apr 27, 2017 at 6:29 AM
  12. Pavan Dipak Girjapure posted a new thread.

    Graph Visualisation Challenge 2017

    Hello ChandooItes, First of all let me thank chandoo for this interesting and brutally helpful site. Now, lets begin the challenge: Can...

    upload_2017-4-27_10-49-40.png upload_2017-4-27_10-53-22.png

    Forum: Excel Challenges

    Apr 27, 2017 at 6:26 AM
  13. NARAYANK991 replied to the thread conditional formatting formula to modify.

    Hi , Can you give some examples of what you mean by changing selection in leave type , so that I can make the same changes at my end and...

    Apr 27, 2017 at 6:23 AM
  14. NARAYANK991 replied to the thread Sub Worksheet_Change Question.

    Hi Paul , See if this works : Sub Worksheet_Change(ByVal Target As Range) Dim E As Object, F As Variant, j As Long, lr1 As String...

    Apr 27, 2017 at 6:20 AM
Loading...