Pairing up people with conflicting data

[DKMI]

I am looking at using data to suggest 'buddies' within an org based on their knowledge. Ie. pairing people with poor skills in a topic with people who are awesome in a topic.

The data looks a bit like this:

Person	Skill	Skill level
Derek	Excel	Poor
Peter	Public speaking	Intermediate
Sarah	Excel	Advanced
Judith	Alteryx	Intermediate

And in this example I would want to pair Derek with Sarah because he is poor and she is advanced. Judith and Peter have no matches:

Person	Skill	Skill level	Person	Skill	Skill level
Derek	Excel	Poor	Sarah	Excel	Advanced

Any thoughts from the hive mind?

[binuacs]

@DKMI One way of doing this

[DKMI]

Cute solution.

Thank you!