+ Reply to Thread
Results 1 to 4 of 4

Is there a way to configure data validated columns to accept multiple entries

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2013
    Posts
    11

    Is there a way to configure data validated columns to accept multiple entries

    Is there a way to make multiple selections when using a Data Validation dropdown? I have attached a sample workbook in the event that anyone has a solution they would like to try out?

    MichaelSample Workbook (Excel_Forum).xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Is there a way to configure data validated columns to accept multiple entries

    In a single validation I don't believe so... you could do what you are doing and then have a concat or just straight combine the three in a new column that would be used later.
    =[@[Rel_Prob]]&","&[@[Add_Aff]]&","&[@[Rel_RI]]
    But it will be interesting to see if someone has an all inclusive way of doing this in a single validation... I just don't see it working with the functionality of those.
    -If you think you are done, Start over - ELeGault

  3. #3
    Registered User
    Join Date
    11-13-2014
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Is there a way to configure data validated columns to accept multiple entries

    Thanks El, I'll try your formula

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Is there a way to configure data validated columns to accept multiple entries

    There is a way and it is explained by Debra Dalgleish on her Contextures website at this URL http://www.contextures.com/excel-dat...-multiple.html
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Data validation list multiple options problem when entering none validated data
    By ThomasCarter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 05:53 AM
  2. Counting Two criteria in two columns within Data Validated cells.
    By datadrivenrecruiter in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-11-2012, 03:56 PM
  3. lookup 2 columns that are data validated wont return correct info
    By imatthews2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 02:31 PM
  4. Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns
    By nzxt1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 01:17 AM
  5. Replies: 3
    Last Post: 03-09-2007, 05:11 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