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?
Cute solution.
Thank you!