Results 1 to 24 of 24

Data Validation Hide Previously Used Items in Dropdown

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2010
    Location
    Youngstown, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    182

    Data Validation Hide Previously Used Items in Dropdown

    I would like to take my son's little league baseball team roster and create a drop down list that shrinks as it is used. I will try to explain more clearly below and have attached a mock file that would help best.

    I have 12 players with uniform numbers 1-12. I have named the players names "PLAYERS" and used a VLOOKUP to access their uniform numbers in the defined group called "UNIFORMS". For each inning, I would like to make sure I use each field postion/player once and only once so as the position/player is used up it doesn't show up in the validation drop down list again (I also defined the positions as "POSITIONS"). This prevents me from placing two different players in the same position within the same inning and creating confusion at game time. Column D is an example of a good setup with all positions/players used once and Column E is an error because of multiple posistions. Note: There are supposed to be (2) SIT positions as this age group has 10 field players and 12 players per team which means two players will need to sit each inning.
    Attached Files Attached Files
    Last edited by cheddarthief; 04-28-2010 at 05:02 PM. Reason: Not actually solved

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