• 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

    Declare integer values globally

    Just to add an alternative to the above, as you're not actually making any changes to the integer value and purely using it as a reference in the sub examples you listed you could always pass it as a parameter to the other sub routines: Sub Main() Dim i As Integer ' loop thru sheets and...
  2. D

    Sum Opening Balance Based on Filtered Criteria

    Hi Shaikhrulez, Replacing your formula with =SUMIF(B5:B34,"<"& SUBTOTAL(5,B5:B34),D5:D34) should work. Example attached. It should provide your opening balance for whatever date selection you make.
  3. D

    Edit X-Axis to Show Categories

    You could always use a custom number format for the axis: "Bucket" #,##0
Back
Top