Discussion Finding the optimal division of two groups in Excel
https://techcommunity.microsoft.com/t5/excel/finding-the-optimal-division-of-two-groups/m-p/650791#M31759
<P>I have a project portfolio management problem, which – I think – can be handled as a mathematical problem. Therefore I would like to solve it in excel.<BR /><BR />But be warned, I am far from an expert user in excel.<BR /><BR />Here is the situation: I have a list of 22 projects that I want to divide into two groups for portfolio management reasons.<BR /><BR />Each project is staffed by 1-5 of my colleagues.<BR /><BR />I want to find the optimal division of the 22 individual projects into two groups in the way that minimizes the number of people who are part of both groups.<BR /><BR />How do I do that?<BR /><BR />I have an excel sheet with the projects in column a, colleagues in row 1 and then an x in relevant the intersections between names and projects (if the person in question is working on that specific project).</P><P> </P><P>Am I wrong in thinking that some formula or function can solve this problem for me and find the optimal solution?<BR /><BR />Best,<BR />Martin</P>Mon, 27 May 2019 19:29:09 GMTMartinSkovbjerg2019-05-27T19:29:09ZFinding the optimal division of two groups
https://techcommunity.microsoft.com/t5/excel/finding-the-optimal-division-of-two-groups/m-p/650791#M31759
<P>I have a project portfolio management problem, which – I think – can be handled as a mathematical problem. Therefore I would like to solve it in excel.<BR /><BR />But be warned, I am far from an expert user in excel.<BR /><BR />Here is the situation: I have a list of 22 projects that I want to divide into two groups for portfolio management reasons.<BR /><BR />Each project is staffed by 1-5 of my colleagues.<BR /><BR />I want to find the optimal division of the 22 individual projects into two groups in the way that minimizes the number of people who are part of both groups.<BR /><BR />How do I do that?<BR /><BR />I have an excel sheet with the projects in column a, colleagues in row 1 and then an x in relevant the intersections between names and projects (if the person in question is working on that specific project).</P><P> </P><P>Am I wrong in thinking that some formula or function can solve this problem for me and find the optimal solution?<BR /><BR />Best,<BR />Martin</P>Mon, 27 May 2019 19:29:09 GMThttps://techcommunity.microsoft.com/t5/excel/finding-the-optimal-division-of-two-groups/m-p/650791#M31759MartinSkovbjerg2019-05-27T19:29:09Z