Home » Forums » Open Source Learning Center » Question and Answer

Need a help with an easy task

Submitted by chosen on 31 October, 2014 - 20:18

Hello, I have a question about, what to do to solve a task where is 8 employees and 8 jobs, each one employee should take only 1 job, and it should be done this, so that to take a minimum time for all 8 jobs done.Here is an excel table attached below.

AttachmentSize
1.xlsx9.95 KB
‹ conditional formatting lock a cell and insert formula in it based on value in another cell using vba in excel ›
»
Nick's picture

create all combinations of

Submitted by Nick on 1 November, 2014 - 07:38.

create all combinations of all employees doing all jobs, and look for the minimum...

»

question

Submitted by chosen on 1 November, 2014 - 15:59.

can you describe how to do all combinations?

»