Hi!

I want to use the Solver to find the best combination possible to get the highest % between all possible combinations.

Here are the details:
- Each variable has a condition (i.e.: Variable 1: Value in TableX[ColumnY] is between 3 and 6) that must be True
- Each variable has a total success % [Count(condition is True)/Count(SUM(True, False))]
- Sum(Weight)=1
- Maximize the % of success with a combination of each variable
- **IMPORTANT** the conditions are cumulative! So, you can have a combination of 1 and 2, 1 and 2 and 3, 2 and 3, etc. and all must be meet at the same time.


Here is an exemple table. (My complete table has 68 different variables):

Click image for larger version. 

Name:	Help Solver.png 
Views:	17 
Size:	12.5 KB 
ID:	9642

Thanks !