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

    Macro Confirmation

    Shaun, I updated the code. I had to edit the range to include all the cells that were listed in the macro code after which everything worked fine.( see below) Sub Confirm() Dim UserChoice As Variant UserChoice = MsgBox("Are you sure you want to do that?", vbYesNo, "CONFIRM") If UserChoice...
  2. A

    Macro Confirmation

    Hey thanks Shaun... I appreciate it very much. I'll update the code and give it a try!!
  3. A

    Macro Confirmation

    LukeM Thanks for the reply.. I am very grateful. Can you tell me how the above code relates to macro code below? Sub ClearCells() ' ' ClearCells Macro ' ' Keyboard Shortcut: Ctrl+Shift+C ' Range("B4:C4").Select Selection.ClearContents Range("C5").Select Selection.ClearContents...
  4. A

    Macro Confirmation

    Hello Group I recorded a macro and assigned it to a button that clears cell contents in a excel sheet. The sheet is protected except for the cells that allow entry. The macro works fine, but I was thinking it would probably be a good idea to have the user confirm they want the cells...
  5. A

    Multi Criteria Average

    Narayan, You are correct about columns C&D. The D63-E61 accomplishes max date - min date. Your formula works perfectly and seems to be more efficient and simpler than the one that me and a co worker came up with. Thank you... this is the best forum on the planet!!!
  6. A

    Multi Criteria Average

    Thanks Luke, I did not consider how a zero in the 1st row or any row for that matter would affect the integrity of the numbers, and how prorating although a good idea when dealing with actual earnings, not so much when no earnings have occurred. After looking at how the earnings would avg...
  7. A

    Multi Criteria Average

    I have a follow up question. I have been researching the issue of averaging with zero. For example, if for the period 01/01/2012-4/18/2012 was zero, and lets add 1234.00 for period 1/1/2010-12/31/2010. The formula returns $744.67. If I look at the look at the 838 day period which is approx...
  8. A

    Multi Criteria Average

    No problem.. your help is appreciated
  9. A

    Multi Criteria Average

    Luke M, Thanks for the simplification of the prorating formula. I had to modify your formula recommendation for the numbers in column E. I failed to mention that I wanted this average to return in 1 cell so the copy down would not work. This is what I did...
  10. A

    Multi Criteria Average

    I have a problem. I have a project that consists of 3 columns and 5 rows. The 1st 2 columns contain dates ( 5 rows) from and thru, and the last column contains currency. The 1st row will contain a date period less than 365 days whereas the subsequent rows will contain from and thru dates...
  11. A

    Dynamic/Automate Dates

    Thanks for the recommendations and your assistance...
  12. A

    Dynamic/Automate Dates

    Hello Hui, Your formula gave the following result using 03/09/2009 3/9/2009 3/9/2008 3/8/2009 3/9/2007 3/8/2008 3/9/2006 3/8/2007 3/9/2005 3/8/2006 3/9/2004 3/8/2005 This is what I needed for the project. 3/9/2009 3/9/2012 4/11/2012 3/9/2011 3/8/2012 3/9/2010 3/8/2011 3/9/2009...
  13. A

    Dynamic/Automate Dates

    Narayan, Thank you very much. You are correct it works perfectly I was attempting to work with the date,year, month functions as you have demonstrated but was not able to figure out how to work the "today" into the process to return the current year. Your formula(s) demonstrate a level of...
  14. A

    Dynamic/Automate Dates

    Sure, 7/17/2011 4/11/2012 7/17/2010 7/16/2011 7/17/2009 7/16/2010
  15. A

    Dynamic/Automate Dates

    NARAYANK991 Your formula works perfectly except the input date will not always be 03/01/. It could be any date thru out the year. The month and day in the self population should be consistent with the input date. I tried altering your formula to say...
  16. A

    Dynamic/Automate Dates

    Good Morning, Thank you for the replies. I will try the recommendations this evening after work and post the outcome. As mentioned I appreciate the responses and help
  17. A

    Dynamic/Automate Dates

    Narayank991, The number entered would be 03/01/2009 and would populate as follows: 3/1/2012 4/10/2012 3/1/2011 2/29/2012 3/1/2010 2/28/2011 3/1/2009 2/28/2010
  18. A

    Dynamic/Automate Dates

    Narayank991 To answer your question the date entry would be in a single cell so lets say K1 and the populating data would be in K2-l2,K3-L3 etc to the 5th row if applicable. with regards to your question about the 5th year, in the example the date 03/1/2009 is < than 5 years ago so...
  19. A

    Dynamic/Automate Dates

    Sure Narayan The dates are ascending from the lower rows. We are trying to represent approximately a full year from the primary date and the primary day and months should always display in the left column with the years ascending. I apologize for the initial post that did not represent...
  20. A

    Dynamic/Automate Dates

    Thanks in advance for any help that is provided. I have a project that I am working on that requires several things to happen The format is set up to when a date is entered in a primary cell, up to 5 rows below which represent up to 5yrs( if applicable) should populate but of course this...
  21. A

    Thank You's

    I agree with you, the help and participation in the forum is 2nd to none. And we should all be thankful.. Thanks for your post
  22. A

    Count Dates Using SumProduct

    Hui, You are one of the reasons why this is the best excel blogs on the planet. I appreciate your help with this problem. Thank you for sharing your expertise with me and the rest of the Chandoo blog community!!
  23. A

    Count Dates Using SumProduct

    Hui, I will be sending the file directly.
  24. A

    Count Dates Using SumProduct

    OK try this link.. https://cid-53e3aed6ab1594d6.office.live.com/self.aspx/.QuickDocuments The file is named; compare test2 modified for skydrive
  25. A

    Count Dates Using SumProduct

    OK Hui, this is the link to my skydrive. Hopefully you can get to it https://cid-53e3aed6ab1594d6.office.live.com/view.aspx/Reserve%20Sheet%20Revision/Compare%20Test2%20modified%20for%20skydrive.xlsx
Back
Top