+ Reply to Thread
Results 1 to 2 of 2

data validation : List , data from single cell conatining (multiple values) VALUES

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    xcver
    MS-Off Ver
    2007
    Posts
    5

    data validation : List , data from single cell conatining (multiple values) VALUES

    Friends, can we apply data validation: list from a single cell containing many values...

    e.g A B C............
    1 12,24,36,48 (in 1 cell) now referring to a1 cell data in C1, using data validation List: data must be 12
    24
    36....
    i tried to use nested formula.... doesn't worked.... if possible then your advice is needed

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: data validation : List , data from single cell conatining (multiple values) VALUES

    Not possible.

    The source must be either a reference to a range of cells or a manually entered comma delimited list.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. [SOLVED] data validation indirect where multiple values show specific list
    By skip2mylew in forum Excel General
    Replies: 4
    Last Post: 02-09-2014, 05:35 PM
  2. [SOLVED] Single cell Comma Separated Values to validation list [DIFFICULT QUESTION]
    By jgema in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-31-2013, 08:48 PM
  3. Replies: 12
    Last Post: 01-22-2013, 06:06 PM
  4. Data Validation List: No empty or blank cell values
    By SiLeNCeD in forum Excel General
    Replies: 0
    Last Post: 11-14-2012, 06:41 PM
  5. Replies: 2
    Last Post: 02-20-2012, 06: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