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

    boolean constraints in solver

    Okay, attached. Just to be clear, the sticky wicket is that the values in column AH must be either 0 or >=3000, unless there's a non-zero value in column AF already. The constraint AJ28=1 is the problem. Change one of the AH variable values such that AJ28<>1, and the solver will fail.
  2. U

    boolean constraints in solver

    There are no error values in any of the cells. Forgot to mention: using GRG Non-linear solving.
  3. U

    boolean constraints in solver

    Hi all -- I'm trying to set up a complex Solver problem, and I ran into a brick wall. Eighteen of the variable cells have a boolean constraint. Specifically, the value needs to be either $0 or >=$3000, unless another value two columns over <>0. For each row, I've made a boolean value with a...
  4. U

    Auto-sort by count of value in pivot table

    Hi folks -- I'm trying to create a dashboard with dynamic charts and slicers in Excel 2010. I have a pivot table set up that shows the count of how many customer complaints we had in various categories, with a slicer that lets you select what year you want to look at. This makes a nice bar...
  5. U

    Lock cells based on a condition [SOLVED]

    Perfect! This is the behavior I'm looking for. Thank you, Sir -- and Luke and Sam, too!
  6. U

    Lock cells based on a condition [SOLVED]

    Yes, still not fixing the problem. I took all the sensitive info out of the spreadsheet and posted a sample here: https://docs.google.com/file/d/0B-smcV0qB2CzbVl5NGU4ZXN3R0E/edit?usp=sharing
  7. U

    Lock cells based on a condition [SOLVED]

    When I re-open the workbook, I get the error I mentioned above. Only if I manually re-run ProtectMySheetFirst does the error go away.
  8. U

    Lock cells based on a condition [SOLVED]

    Code name is Sheet1.
  9. U

    Lock cells based on a condition [SOLVED]

    Thanks Luke, Yes, that fixed the problem. Just one more thing! This VBA only works if I manually run the first function (Sub ProtectMySheetFirst) before I start to use the worksheet. If I close it and reopen it fresh, it gives me the same Run-time error '1004'. But I want to hand this...
  10. U

    Lock cells based on a condition [SOLVED]

    Thanks Luke, Getting closer, but one more snag: Your solution does apply to the whole range, and it's nice that it's doing its thing for both of my two conditions now. But the locking only kicks in once you type something in the cell (in column H or I). If I leave column H or I blank (or...
  11. U

    Lock cells based on a condition [SOLVED]

    Thanks Sam! Your method worked. But I'm encountering another problem, which I'm sure is easy, but I rarely touch VBA. That method will check only row #3, but I need it to perform this check on all rows. So I tried changing the second part of the code to this: Private Sub...
  12. U

    Lock cells based on a condition [SOLVED]

    Hi folks -- I need a little help. I'm setting up a spreadsheet that several people will add data to, and I'm trying to set some strict data validation rules. Column H asks, "Is this customer feedback?" possible values yes/no, and Column I asks "Is this a risk issue?" also yes/no. Columns J-M...
  13. U

    what did I turn on?

    Aha! It was an outline, you're right. Turned off now. Thanks!
  14. U

    what did I turn on?

    Help! I pressed some button combination, and it made an area appear between my formula bar and my cells. What is it, and how can I make it go away? It has a 1 and a 2 in little squares at the right side, and if I click them they make a blank area appear/disappear with a plus/minus sign. (Is...
  15. U

    Return named data range in a cell

    Thanks Jordan! Funny that you can't keep a data range name in a cell, but the links you sent did the trick. Also, the "choose" function is much less clunky than a series of nested if statements. You rock.
  16. U

    Return named data range in a cell

    Hi folks -- I'm trying my hand at making a simple dashboard, but I've run up against a frustrating problem. I'll tell you the bottom line first, and then the details. I want to get a formula to return a reference to a named data range in a cell, but the formula constantly returns a digit...
Back
Top