Data Validation list + other text?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Data Validation list + other text?

  1. #1
    New Member
    Join Date
    Nov 2012
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Validation list + other text?

     
    I would like to enter a data validation list along with two other options. I don't want to add the options to the actual list nor do I want to make a new list just for two other options.
    Is is possible to enter both in the data validation source box?

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,836
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation list + other text?

    what are the 2 other options ? Data validation can use a list and can open a new drop down driven by the value in the first one.

  3. #3
    New Member
    Join Date
    Nov 2012
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation list + other text?

    In the drop down list I would want the items in the Named Range along with other choices. i.e., A Name Range called Fruits that has two additional choices like Tomato and Corn. I don't want to add the extra choices to the Fruit's List and I dont want to make a Name Range for just two extra choices.

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,836
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation list + other text?

    is there a fruits list ?

    or is the drop down just fruit or vegetable ?

  5. #5
    New Member
    Join Date
    Nov 2012
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation list + other text?

    The Named Range is "Fruit" there are 10 types of fruit in the list. I would like to add to other choices to that list with out actually adding them to the the named range and with out making a new named range.
    For example, when trying to make a data validation list, I tried to enter this in the source box:
    =Fruit,Tomato,Corn

  6. #6
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,836
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation list + other text?

      
    put 10 blank cells under the 10 fruits and make the block of 20 "fruit table", then you can add and delete at will

    I am struggling to understand why you are limited to 10 fruits yet want to add an eleventh.....

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com