• 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...

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

Search results

  1. S

    Problem in VBA code for “Zoom_in_Profit Loss”

    Dear Vletm, Received with thanks, Please go through my file and send me after correction. Thanks in advance.
  2. S

    Problem in VBA code for “Zoom_in_Profit Loss”

    Dear, I did all the changes as told me in previous mail and I have the following problems:- Please correct me so, I can get the same result like "Zoom_in_Balance Sheet" in the "Zoom_in_ Profit & Loss.xlsm" file also. (Modified worksheed attached)
  3. S

    Problem in VBA code for “Zoom_in_Profit Loss”

    Dear, With reference to the attachment, I customized the Please help me to correct the VBA code in “Zoom_in_Profit Loss” [Sheet6 (Income)] so get the result like the Balance Sheet Zoom. [Sheet6 (Income)] according to “Zoom_in_Balance Sheet” of [Sheet 1 (Balance Sheet)] but, it is not working...
  4. S

    Use of Max,Min,Average formula

    Dear Ninja, I want to say thanks for help me.
  5. S

    Use of Max,Min,Average formula

    Dear, With reference to the attachment, I applied MAX; MIN; AVERAGE formula with selected range/ period manually according to the mentioned above (01-Mar-17 to 15-Mar-17). The further request, I want to get the value automatically by the change of the period with the help of a formula.
  6. S

    Error Alert Message

    Dear, Received with thanks, I want to inform you that is not for others users, basically, my object is that I can do the copy of cell from here [column “A”] but, I could not do the post and insert here in the Column”A” from another sheet. If I do the insert and post here in Column “A” its...
  7. S

    Error Alert Message

    Dear All, With reference to the attached sample file, I would like to show the “Error Alert” If we insert any data/statement in the column “A” with the help of Data Validation Tools. Thanking you.
  8. S

    Sumproduct Formula

    Dear AlanSidman, Received with thanks for the quick reply, but, sorry to say it is not working. For the right answer, Please go through the following which I received from NARAYANK991. Dear Narayan, Thank full to you for elaborate the solution.
  9. S

    Sumproduct Formula

    Dear All, With reference to the attached sample file, the SUMPRODUCT formula at [column”4H”] to get the return of value with two conditions Total of BREAKFAST & PERIODICAL (18-Feb-2018 to 21-Feb-2018), but returning value is Zero which is wrong. May I know what is wrong with SUMPRODUCT...
  10. S

    Sumifs formula #Value!

    Dear Bosco & AliGW, Received with thanks, Ms AliGW can you please elaborate the following sentence with the formula. "The ranges in the SUMIFS need to be the same size as each other and only one column in width."
  11. S

    Sumifs formula #Value!

    Dear All, With reference to the attached sample file, I applied SUMIFS formula, but I am getting the wrong answer “#Value! May I know what is wrong with SUMIFS formula?
  12. S

    Macro button

    Dear All, Thanks to all.
  13. S

    Macro button

    Dear, Received with thanks, with reference to the above, please find the photo shoot of Visual Basic command. May I know where I can put the “Sheet1”? Thanks.
  14. S

    Macro button

    Dear, Received with thanks, It is working, please tell me where I was wrong?
  15. S

    Macro button

    Dear, Sorry, It is not working.
  16. S

    Macro button

    Dear, To print that is at the Sheet1, which I am trying to get the print with help of the micro button at Sheet2.
  17. S

    Macro button

    Dear All, With reference to the attach a sample file, I have a micro button at Sheet2 to get the direct print by a single click which I am not getting. However, I am getting the print on active sheet1. May I know what is wrong with a Sheet2 micro button?
  18. S

    Macros run by one click

    Hi, So far I have a button to start the macro in excel, but that's really uncomfortable. Basically, I would like to double click a cell/icon to run the macros. Has anyone any Idea?
  19. S

    Sumif formula mistake

    Dear Thangavel D, You are absolutely right and I think the above sumifs formula is perfect to avoid the double effect.
  20. S

    Sumif formula mistake

    Dear John, Thanks to solve my problem.
  21. S

    Sumif formula mistake

    Dear Narayank, Actually, what I want it will be cleared with the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation. Thanking you.
  22. S

    Sumif formula mistake

    Dear Naresh, Received with thanks.
  23. S

    How to get the sum of negative value

    Dear All, With reference to the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation. Thanking you.
  24. S

    Sumif formula mistake

    Dear All, With reference to the attached sample file, when I apply the following formula in cell “B20” that is not working to avoid the duplication of negative value in the “Total Housing”. May I know what should I do to get the correct input?
  25. S

    How change the color in number

    Dear all, Received with thanks for giving me the new idea.
Back
Top