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.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,214,492
Messages
6,119,868
Members
448,923
Latest member
emle1976

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top