Results 1 to 3 of 3

Optimize and pairing

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    2

    Optimize and pairing

    Hi,

    I have a bunch of subjects that I need to pair them up in a group of 2, but some subjects cannot be paired with some of them, the relationships between them is attached: The cells "FAIL" means that they cannot be paired together, e.g.: No6 and No3 cannot be paired together.

    The subjects cannot be repeated in multiple pairs, i.e. if No7 is paired with No9, No7 cannot be paired with No1, No2, etc...

    Are there any ways to optimize the pairing with the maximum number of pairs as an outcome?

    Thank you so much!

    Dexter
    Attached Files Attached Files
    Last edited by chengdexter724; 04-14-2020 at 11:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pairing workdesks
    By NiCeXoTiC in forum Excel General
    Replies: 1
    Last Post: 01-28-2020, 06:04 AM
  2. Pairing data with itself?
    By amolo in forum Excel General
    Replies: 1
    Last Post: 07-13-2016, 04:17 PM
  3. [SOLVED] Pairing people according to strengths
    By Petrus81 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-20-2015, 08:11 AM
  4. Pairing/Grouping People
    By gslgroup in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2014, 02:58 PM
  5. help pairing columns
    By YORKS12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 01:16 AM
  6. Data Pairing
    By frankymute in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-23-2014, 01:00 AM
  7. Random pairing
    By woodnwine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2010, 01:01 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