Hi all,
I have been surfing the internet to find relevant VBA modules to fulfill my needs. Unfortunately, I was unable to find a solution.
Normally, I would have 100 mentors and 1300 mentees (roughly, 1 mentor to 13 mentees). I hope I can generate a list of matching results. (See the spreadsheet "(Ideal result)Mentees - Mentors")
Prefetching criteria are:
- Programme (Q5)
- Gender (Q4)
- Code (Q6)
Ideally, those mentor-mentees who fulfilled all the above 3 criteria can be matched first. Next, those with 2 out of 3 criteria would be matched, followed by 1 out of 3 criteria matched. Lastly, the remaining mentors and mentees can be matched (Just simply putting on sequence/randomly is fine)
At last, it would be nice to have the option to choose the no. of mentees required by the mentor (Q7). It's fine if this function does not work, then just each mentor has an average no. of mentees.
Appreciate your help. Thank You very much!
I have been surfing the internet to find relevant VBA modules to fulfill my needs. Unfortunately, I was unable to find a solution.
Normally, I would have 100 mentors and 1300 mentees (roughly, 1 mentor to 13 mentees). I hope I can generate a list of matching results. (See the spreadsheet "(Ideal result)Mentees - Mentors")
Prefetching criteria are:
- Programme (Q5)
- Gender (Q4)
- Code (Q6)
Ideally, those mentor-mentees who fulfilled all the above 3 criteria can be matched first. Next, those with 2 out of 3 criteria would be matched, followed by 1 out of 3 criteria matched. Lastly, the remaining mentors and mentees can be matched (Just simply putting on sequence/randomly is fine)
At last, it would be nice to have the option to choose the no. of mentees required by the mentor (Q7). It's fine if this function does not work, then just each mentor has an average no. of mentees.
Appreciate your help. Thank You very much!