+ Reply to Thread
Results 1 to 2 of 2

Need to prevent duplicate and "mirror" pairings being selected in DropLists

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Need to prevent duplicate and "mirror" pairings being selected in DropLists

    Attached shows a Range of models, and the dependent Ranges of models to which each one can be compared.

    User has three boxes where he selects a model in the DropList, then selects from the Dependent DropList the Model against which it will be compared.

    Problem 1: If user selects "A vs B" in a box, then selects "A" in another box, how do I prevent "B" from being selected as the comparison again?

    Problem 2: If user selects "A" v B" in one box, how do I prevent him from selecting the reverse ("B v A") in another box?

    Any suggestions, pointers or solutions accepted gratefully

    Ochimus
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: Need to prevent duplicate and "mirror" pairings being selected in DropLists

    I think it woud be much easier to prepare userform with 6 comboboxes and "rules" to fill them than just to do it with limiting lists with formulas (I do not say the second is impossible - just more work and complicated formulas/named ranges playing). But, if for some reason VBA is not allowed - how about using some helper ranges/columns in the worksheet?
    Best Regards,

    Kaper

+ 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. [SOLVED] Prevent Duplicate Receipt Number in Three Column [ e.g. Column "A", "B", "C" ]
    By MrsCharmy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-31-2017, 08:40 AM
  2. Replies: 0
    Last Post: 03-21-2014, 09:58 AM
  3. Replies: 4
    Last Post: 04-25-2013, 06:18 PM
  4. Using "mirror image" of cells to delete duplicate data?
    By abcd1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2007, 09:12 AM
  5. if "a" selected from dropdown menu then show "K" in other cell
    By LEGALMATTERS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 01:10 PM
  6. [SOLVED] how to use "distinct" to prevent duplicate records
    By crimsonkng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2005, 01:05 AM
  7. [SOLVED] How to prevent "Reviewing" toolbar from "automatically" appearing?
    By FishHead in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 12:06 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