Finding best match from two sets of data

chickensoup

New Member
Joined
Sep 18, 2014
Messages
3
I'm trying to match the skills offered by mentors to the skills required by mentees.
In the tables below, 1 = yes, 0 = no
How can I match the people from table 1 to the best match in table 2?

Thanks


Time
Project
Confidence
Interview
Presentation
Networking
Excel

Jon​

1​

0

1​

1​

0​

0

1​

Karen​

1​

1​

1​

0​

1​

1​

0

Adam​

0

1​

0

1​

1​

0

1​

Steve​

0

1​

1​

0

0

1​

1​

<tbody>
</tbody>
Time
Project
Confidence
Interview
Presentation
Networking
Excel

Dave​

0

1​

1​

0

1​

1​

0

Betty​

1​

0

0

1​

0

0

1​

Jeff​

1​

1​

1​

0

1​

0

0

Sheila​

0

0

0

1​

1​

1​

1​

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

maheshmaxi

Active Member
Joined
Dec 16, 2008
Messages
252
your question is not clear, do you want to match Jon's Time (1) with Dave's Time (0) and so on? can you make it clear?
 

chickensoup

New Member
Joined
Sep 18, 2014
Messages
3
I'd like to match all of Jon's data with the closest possible match in the second table
i.e someone who has chosen the same or closest to the same criteria across the board.

The same would then need to happen to the next mentee until everyone is matched as best as possible.

I hope that is clearer as I really need help!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,625
Messages
5,523,970
Members
409,548
Latest member
Buildingbysea

This Week's Hot Topics

Top