• 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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