How to set solver to only use a range of acceptable variables

sharmon

New Member
Joined
Sep 21, 2014
Messages
10
Hi,

How do i get solver to only use a specified list of variables (i.e. 1, 4, 7, 8) to achieve a max result?

I've tried using constraints but there i only have the option of inputting cell reference =>1 and =<8, but this would use all variables between 1 and 8 and not only the 4 mentioned above.

I thought this should be something simple, anyone?

Thanks in advance!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,205
Messages
5,527,399
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top