Problems matching mentors and mentees on excel

chickensoup

New Member
Joined
Sep 18, 2014
Messages
3
Hi All,

I'm trying to match mentors and mentees through their selected criteria on application forms.
I've created two sheets, one with mentor information and one with mentee, with 200 entries on each.

I have entered the values as 0 for no, or 1 as Yes where they have the option to select what they would like to either receive or give mentoring on. There are 11 options.

Is there a tool or formula that will find the most suitable match for each mentee?

I hope all that makes sense? I tried to upload an image of the spreadsheet but there doesn't seem to be a function for that here.

Thanks.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,062
Members
409,684
Latest member
Nazmul00

This Week's Hot Topics

Top