+ Reply to Thread
Results 1 to 2 of 2

Rank and provide best matches between two tables

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    US
    MS-Off Ver
    2007
    Posts
    6

    Smile Rank and provide best matches between two tables

    Hi there.

    I've created some internal MS Forms for my company that are attempting to gather information from a requestor regarding the skillsets they are looking for. There is another form for volunteers who can submit their level of expertise across those same skills. The goal is to have the logic on the Request tab -> column 'Best Matches' display the ID numbers (separated by comma, text join?) ranking them from highest matches to lowest for only top 3.

    On the skills logic tab, I've created a value associated for each level of expertise. If a requestor asks for an intermediate in Tableu, and there are two records in volunteer, where as one is intermediate, and the other is Expert, The one with Expert should be returned first, where as the other would be returned second.

    I'm not sure if it's possible to add up all of the associated points across all the matches, rank them, then return only the ID of Volunteers of top 3 in single column. This seems like a combination of arrays, rank & or big, but I'm unable to come up with anything. Maybe there needs to be one column on the Request tab for each skill i.e. Tableau rank, Sharepoint rank. Maybe that's easier to return the top 3 with out adding in the sum of the entire array into one column?

    Struggling to find an elegant solution to this one. Any help would be amazing :-)

    Tableu
    Sharepoint
    Power BI
    Smartsheet
    MS Excel
    MS Word
    MS Powerpoint
    MS Project
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-05-2022
    Location
    Indonesia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    51

    Re: Rank and provide best matches between two tables

    maybe vba is best way to do (sadly I don't know how to do it) since it should iterate all requirement like :
    request 1 need : expert in sharepoint, power bi, need intermediate in smartsheet, novice in tableu and ms excel, and need no expertise in ms word, ms powerpoint, and ms project

    then look 1 by 1 in volunteer list who have the closest skill with the request 1

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two tables, find matches, and extract rows based on matches.
    By arcticspace in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2022, 06:35 AM
  2. Compare two tables and find records without matches
    By Isaacliu in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-14-2019, 11:01 PM
  3. Replies: 8
    Last Post: 08-29-2018, 12:30 PM
  4. Match-Up two tables where one table has multiple possible matches
    By kevsvette in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-09-2016, 02:28 PM
  5. Replies: 1
    Last Post: 02-28-2014, 04:47 AM
  6. Rank with conditions from two tables
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2013, 01:17 AM
  7. [SOLVED] Rank via Formula Tables
    By marreco in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-29-2012, 07:49 PM

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