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

	Person	A	B	C	D
Assign
#1		YES	YES	0	0
#2		YES	0	0	0
#3		0	YES	YES	0
#4		0	0	0	YES

<tbody>
</tbody>

Ï 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!