Share via

Solver constraint cell reference broken

Anonymous
2018-10-06T18:20:05+00:00

I'm trying to solve a problem and need to add a constraint to the cells highlighted with red:

However, for whatever reason, Excel is throwing an error when I add the range of cells:

All I do is select the cells with the mouse while holding down cmd, the cell reference is $T$5:$T$10;$T$12:$T$18. This should be totally valid, but Excel some has problem with it. I have no idea how to fix it, I think it happens because I'm on Mac. Do you know how to fix this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-10-06T21:38:16+00:00

    Hi.  The AllDiff must be one continuous range.  It can't be broken up like that.

    0 comments
  2. Anonymous
    2018-10-07T12:41:51+00:00

    Why on EARTH??? This makes no sense...

    0 comments
  3. Anonymous
    2018-10-07T14:24:53+00:00

    Hi.  Feel free to post your problem if you would like.

    I would be curious to see this optimization problem.

    0 comments