Results 1 to 2 of 2

Pair 2 people based on tiered criteria

Threaded View

codu123 Pair 2 people based on tiered... 12-08-2022, 12:08 PM
Kaper Re: Pair 2 people based on... 12-09-2022, 04:30 AM
  1. #1
    Registered User
    Join Date
    01-05-2021
    Location
    Massachusetts, USA
    MS-Off Ver
    MS office plus 2016
    Posts
    2

    Pair 2 people based on tiered criteria

    I need to pair 2 people at random, but I need a way to "try" and avoid pairing people with the same skills. I attached an example of my data but I can't seem a way to guide the randomizer that people with Skill one should not be paired together. I understand that to match everyone I will need to pair some people with the same skills but I need to add some sort of priority where its really important not to pair skill 1 but it can be ok with 5.

    The way that the priority needs to be is from left to right on skill levels

    has anyone attempted to do this before with any luck?
    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. Replies: 1
    Last Post: 02-17-2021, 02:19 AM
  2. [SOLVED] Random Pair Generation with Multiple Criteria (index/match)
    By vankmj in forum Excel General
    Replies: 11
    Last Post: 05-21-2020, 11:35 AM
  3. Simple pair matching using dynamic criteria
    By Frederik_S in forum Excel General
    Replies: 5
    Last Post: 01-07-2018, 11:03 AM
  4. [SOLVED] Convert Single Pair of Columns to 3 Column (Pair) List
    By kencoburn in forum Excel General
    Replies: 7
    Last Post: 03-04-2017, 01:43 PM
  5. [SOLVED] Identify the pair and calculate the time difference if certain criteria match
    By Chippi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2014, 07:00 AM
  6. [SOLVED] Is populating one cell based on its unfilled pair possible?
    By JYTS in forum Excel General
    Replies: 4
    Last Post: 08-25-2014, 07:59 AM
  7. Pair down results based on input
    By pjbassdc in forum Excel General
    Replies: 6
    Last Post: 09-14-2011, 02:35 PM

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