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

    Insert text with cell click

    This look great. I have a questions though. I am trying to educate myself on VBA basics but have little time to do so. If i needed this to work only in cell A5 or in the range A5:A10 what would I need to do? Thanks
  2. B

    Insert text with cell click

    I have columns that i use for checking off if a project is completed. I insert "x" in those cells and other formulas are activated. I am hoping for an easy way to simply have the "x" entered by just clicking the cell and a second click to erase the "x". I would like for this to have a...
  3. B

    MAXIF

    I avoided using whole column references and there is no recognizable lag time. Much better. Thanks Colin
  4. B

    MAXIF

    Can you further explain the { }. That is what I was currently using but the calculations appear to move from one cell, with the formula, to the next rather slowly.
  5. B

    MAXIF

    Is there a formula that functions as SUMIF but returns the MAX of the sum_range?
  6. B

    Sumif problem

    AVERAGEIF would no work as the quantities of the measurements I need averaged are listed in a separate column. Listing each measurement would add too much the the spreadsheet as well. What im looking for is a formula that will separate data in a particular range depending on the criteria, as...
  7. B

    Sumif problem

    I want to us the sumif as normal but I need the sum_range portion to have a formula incorporated with it. Example: SUMIF(range,criteria,Average(sum_range) or SUMIF(range,criteria,SUM(C;C)*(F:F)) Is this possible in another function?
Back
Top