+ Reply to Thread
Results 1 to 3 of 3

lists and dropdowns

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    chicago, il
    MS-Off Ver
    Excel 2003
    Posts
    7

    lists and dropdowns

    I know how to make a dropdown combo box and link it to a list. My question is, how can I make it so an item on the list can only be used once.
    Here's my example:
    Say I want to make a table where four people are choosing players for a team. Each person gets to choose 10 players from a list of 50 names. Each cell in the table will have a dropdown linked to this list. Once a name is chosen, it needs to be hidden from the list so that it cannot be chosen again.
    Is this possible?
    Thank you

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: lists and dropdowns

    Look at the attached. Disect it and ask questions if you buck anywhere, but I think it would be more or less what you want.

    Credit to JB by the way.
    Attached Files Attached Files
    Last edited by ron2k_1; 07-06-2010 at 02:14 PM. Reason: Credits
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    chicago, il
    MS-Off Ver
    Excel 2003
    Posts
    7

    Thumbs up Re: (solved) lists and dropdowns

    Thanks to you and JB.
    The way I understand it, a number, "key", was assigned to each name and that was used to to create the formula guiding the list. Very good!
    This should work just fine.
    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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