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

    Macro error

    Hi, I am facing an issue with a code. I am a beginer and practicing with writing small codes. I just want to insert a worksheet with desired sheet name. I wrote this code to work like this: if at first time, I don't enter any name or click on "cancel" button, it run macro again and ask for...
  2. D

    Need to add n number of working days in a given date.

    Hi Hui, Thank you so much for the help. I had tried to use Networkdays.INTL but that wasn't helping. I will try to rewrite the formula and contact again if face any issue. Thanks a lot, DJ
  3. D

    Need to add n number of working days in a given date.

    Hi All, I need a help calculating the Turn Around Time. To do this I need to add n number of working days in a given date e.g. if request is raised on Thursday and Turn Around Time is 72 hours i.e. 3 working days then Turn Around Time would be Monday End of Business. I tried to apply if else...
  4. D

    Urgent formula help

    Hi NarayanK991/Hui, I tried again for same problem and found another workaround which is very easy to understand for everybody. As I mentioned in my first post "If we have some numbers Lets say 1,2,2,4,4,4,2,2,1,2 in a range eg. A1:A10. I need count of unique numbers". I wrote an array...
  5. D

    Urgent formula help

    Hi Narayank991/Hui, It is working fine. Thank you so much for the help. DJ
  6. D

    Urgent formula help

    Hi Narayank991, Thank you so much for the help. However, in a situation if range has text values then it is not working. Plz help with that too, I will be very grateful. DJ
  7. D

    Urgent formula help

    Hi All, I need an urgent help with a formula. If we have some numbers Lets say 1,2,2,4,4,4,2,2,1,2 in a range eg. A1:A10. I need count of unique numbers i.e. answer should be 3. plz help
  8. D

    How to apply Rank in Pivots

    Hi Prasaddn, Thank you so much for your efforts and the solution for my problem. However, I am unable to follow step-2 as unable to see Calculation Tab under Pivot Table Option (Tried to find Calculation Tab by right clicking on the pivot table and in the Pivot Table ribbon both). Again to...
  9. D

    How to apply Rank in Pivots

    I am doing the same, however, can a saperate calculated field can be inserted ? Or something else can be done?
  10. D

    How to apply Rank in Pivots

    Hi, How we can apply rank in the pivots eg. if I want to arrange salesmen according to the increasing order of the sales made by them? I am using Excel 2007. Thanks
  11. D

    Reduce File Size

    Hi Hui, Is *.xlsb file format accessible in both office-2003 & office-2007?
  12. D

    How to zip excel files using VBA?

    Is there any method we can zip all the excel files separately (files are saved in a particular folder) using VBA?
  13. D

    How this VBA code is working?

    Hi, I was checking code of a macro but unable to understand the following code: LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Please assist. Thanks
  14. D

    Want to learn Excel Charts

    Hi, I need help on Excel Charts. I am a new excel user and want to learn charts but facing problem with basics. Kindly help me to understand them. If possible provide me a link where there is sufficient information online or I can download files which can help me. I tried a lot using Google but...
  15. D

    Custom View in Excel

    I am facing problem while creating custom view. It is a bulky data file and I use it regularly. I am required to apply filter based on criteria to get the required details. The problem is I have created a custom view in it so that I need not apply filter again and again to view the required...
  16. D

    Excel as executable pdf?

    I have adobe reader-9 installed in my system. Also, I didn't get save as PDF option in Excel.
  17. D

    Excel as executable pdf?

    Hi Hui, I tried to do the same, however, I was unable to view *.pdf as file type. Hence was unable to do so. I don't know if I was doing any mistake. Does the converter you had mentioned in the earlier post can convert the excel file in the execuatable PDF?
  18. D

    Excel as executable pdf?

    Hi Hui, I tried to save an excel file as PDF document but was unable to do so. Kindly assist how I can do this.
  19. D

    Culling similar dates from a series

    It worked Great. Thank you very much. DJ
  20. D

    Culling similar dates from a series

    Hui, This function will not work when years are different. for example, I just want to get that who all are whose birth day falls in march. Obviously years may differ. Please suggest if there is any method to extract this information without taking the help of another column having formula...
  21. D

    Pivot table issue

    Thank you very much Hui for resolving this.
  22. D

    Pivot table issue

    if raw data has filled up in one worksheet and need another then how to add this new data in existing pivot table. I actually have over 80000 records and based on this data I need to prepare a pivot table. I use Excel 2003. Since available rows are 65532, data will not fit in one worksheet so...
Back
Top