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