Results 1 to 2 of 2

Mentor Matching

Threaded View

Lyndsay Mentor Matching 04-28-2020, 12:29 PM
alansidman Re: Mentor Matching 04-28-2020, 12:54 PM
  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    London, England
    MS-Off Ver
    360
    Posts
    1

    Smile Mentor Matching

    Hi,
    i am new to Excel and need to make some way to match mentors and mentees. Currently there are only about 100 but it will increase. We don't have data of the mentees, just the mentors so what I would I deally like is that mentees can fill in a short form and excel spews out a list of 5 possible matches that they can then look up in our catalogue (as previously they have had to trawl through the whole lot to find a mentor). I expect that mentees would like to find a mentor by specialist topic area, clinical qualification, location and perhaps gender. I am attaching the dtaa I have inherited and currently staff can look up lists of peoples names on the first sheet by topic then look for their contact details on the second sheet. I am just hoping to make this a little easier.

    As a complete beginner I would like pointers as to where to start. What tutorials I should be watching/ reading and what i should be searching.

    I have attached the file but removed the names etc.

    Many thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Optimal Mentor-Mentee Pairings Problem
    By ollyo2 in forum Excel General
    Replies: 10
    Last Post: 04-07-2022, 02:37 AM
  2. Replies: 18
    Last Post: 10-08-2017, 04:17 AM
  3. [SOLVED] Alter Matching Sub From matching two Ranges to matching one range and list
    By capson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2015, 10:48 PM
  4. Hello, need a VBA tutor and mentor..
    By Jerry HKA in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-25-2012, 10:57 PM
  5. Need a mentor, VBA codes
    By MUNOZJ187 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-25-2012, 03:53 AM
  6. Automated Excel Workbook (entries, updates, deletions) - looking for mentor
    By bg_enigma1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2012, 10:51 PM
  7. I'm looking my mentor
    By mentor in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-03-2006, 08:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1