PDA

View Full Version : Every possible combination



Amaral87
05-22-2018, 08:24 AM
Hi everyone! I'm trying to find a way to get every possible combination for a single column with 200 values that varies from 1 to 5.

from A7 to A206, when i change the values from 1 to 5, it allocates each task to a machine. The objective is to obtain the lowest value possible in D4 to H4.

The way i figure...i should make a loop for every cell from A7 to A206 between 1 and 5 and get every solution.. Do you know better \ easier way?

Thanks in advance!