View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Quick solver question

Maybe you can use cells with COUNTIF(all cells, this cell) and ask all
these cells to be equal to 1. But with such a nonlinear problem you
will be lucky if you get a solution.

HTH
Kostis Vezerides

On Jul 3, 4:34 pm, "Keith R"
wrote:
I have a range that solver is manipulating. I've set the critera to have the
appropriate min and max values, and to be integers.

I also need each value to be "selection without replacement", e.g. I need a
solution where each value is only used once.

How can I set that as a requirement for Solver?

Thanks,
Keith