Clustering in groups, is it even possible?

[Fyrefox]

Hallo

I have a question about clustering in excel and I don't even know if it is even possible doing it (in excel).

I will give a simple example: There are 4 teachers and 4 assignments. Everyone indicated if he/she has the right expertise to evaluate a certain assignment with (YES).


[TABLE="width: 384"]
<tbody>[TR]
[TD][/TD]
[TD="width: 64"]Person[/TD]
[TD="class: xl63, width: 64"]A[/TD]
[TD="class: xl63, width: 64"]B[/TD]
[TD="class: xl63, width: 64"]C[/TD]
[TD="class: xl63, width: 64"]D[/TD]
[/TR]
[TR]
[TD]Assign[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#1[/TD]
[TD][/TD]
[TD="class: xl64"]YES[/TD]
[TD="class: xl63"]YES[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD]#2[/TD]
[TD][/TD]
[TD="class: xl65"]YES[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD]#3[/TD]
[TD][/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl65"]YES[/TD]
[TD="class: xl64"]YES[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD]#4[/TD]
[TD][/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl65"]YES[/TD]
[/TR]
</tbody>[/TABLE]


Ï want to make 2 groups with the most ideal situation. So per group, 2 persons with the right expertise for the assignments. So everyone in the group should have the expertise to evaluate the assignments given.

For example, the most ideal situation would be:
Group with persons A+B with assignments 1 and 3
Group with persons C+D with assignments 3 and 4

This is of course a small group, but with a larger group things will get more complicated.

Does anyone know how to approach such 'clustering' via excel?

Thank you very much!

 

[Kaper]

One could use Solver (Add-in, which is installed with Excel, but not activated, so you have to activate it) for this task.

 

[Fyrefox]

Thank you!