"Matches" Query

[Robert]

I need to create a query or queries, that return the number of matches on
corresponding fiends in two tables. Table 1 is Applicants, Table 2 is
Mentors. Fields A1, A2, A3..., M1, M2, M3... are a/b/c/d... type values. I
think it should be fairly simple to find the number of intersts in common
between Applicant1 and Mentor1, Applicant1 and Mentor2, etc. but I can't get
started. Can someone point me in the right direction?

The ultimate output is to identify the applicant/mentor pairs with the most
in common, but that might be obvious if we can accomplish the above.

TIA,
Robert

 

[Mike Glen]

Hi Robert,

This newsgroup is specifically for matters dealing with Microsoft Project.
I suggest you try to find a more appropriate newsgroup that deals with
Excel(?) problems.

Mike Glen
Project MVP