Home

Finding the optimal division of two groups

%3CLINGO-SUB%20id%3D%22lingo-sub-650791%22%20slang%3D%22en-US%22%3EFinding%20the%20optimal%20division%20of%20two%20groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650791%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20project%20portfolio%20management%20problem%2C%20which%20%E2%80%93%20I%20think%20%E2%80%93%20can%20be%20handled%20as%20a%20mathematical%20problem.%20Therefore%20I%20would%20like%20to%20solve%20it%20in%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20be%20warned%2C%20I%20am%20far%20from%20an%20expert%20user%20in%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20is%20the%20situation%3A%20I%20have%20a%20list%20of%2022%20projects%20that%20I%20want%20to%20divide%20into%20two%20groups%20for%20portfolio%20management%20reasons.%3CBR%20%2F%3E%3CBR%20%2F%3EEach%20project%20is%20staffed%20by%201-5%20of%20my%20colleagues.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20find%20the%20optimal%20division%20of%20the%2022%20individual%20projects%20into%20two%20groups%20in%20the%20way%20that%20minimizes%20the%20number%20of%20people%20who%20are%20part%20of%20both%20groups.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20I%20do%20that%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20an%20excel%20sheet%20with%20the%20projects%20in%20column%20a%2C%20colleagues%20in%20row%201%20and%20then%20an%20x%20in%20relevant%20the%20intersections%20between%20names%20and%20projects%20(if%20the%20person%20in%20question%20is%20working%20on%20that%20specific%20project).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20wrong%20in%20thinking%20that%20some%20formula%20or%20function%20can%20solve%20this%20problem%20for%20me%20and%20find%20the%20optimal%20solution%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EMartin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-650791%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
MartinSkovbjerg
New Contributor

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.

But be warned, I am far from an expert user in excel.

Here is the situation: I have a list of 22 projects that I want to divide into two groups for portfolio management reasons.

Each project is staffed by 1-5 of my colleagues.

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.

How do I do that?

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).

 

Am I wrong in thinking that some formula or function can solve this problem for me and find the optimal solution?

Best,
Martin

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies