+ Reply to Thread
Results 1 to 2 of 2

How to limit the number of choices in multiple drop-down lists?

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    6

    How to limit the number of choices in multiple drop-down lists?

    Long story short, let's assume that I have a drop-down list in every cell of the range A1:B4 - they offer the same choices, all taken from a different range within the same sheet. What I need to do is to make it so that whenever a user chooses an item from one of the lists (in no particular order) the same item has to disappear from all the other lists in the range A1:B4. In other words, if a user selects "1" in A3, the "1" will not appear in any other list in the above-mentioned range. If he will then choose "2" in "A2", both "1" and "2" won't be available to pick in the remaining lists. I'm absolutely sure it's doable (hell, everything is), but I can't figure out how exactly. Please help me figure this one out, if you can. Thanks!

  2. #2
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: How to limit the number of choices in multiple drop-down lists?

    There u go
    Attached Files Attached Files
    Please consider adding a * if I helped

+ 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. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  2. Replies: 0
    Last Post: 06-02-2009, 10:27 AM
  3. Drop Down with multiple choices?
    By TPD in forum Excel General
    Replies: 7
    Last Post: 02-07-2007, 02:36 PM
  4. Multiple choices in a drop-down list
    By Heidipup in forum Excel General
    Replies: 3
    Last Post: 01-16-2007, 03:33 AM
  5. Drop down list with multiple choices
    By Cindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2005, 09: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