+ Reply to Thread
Results 1 to 5 of 5

Use of conditions on Data validation LIST option

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    26

    Use of conditions on Data validation LIST option

    Hi all,

    I wanted to make the data validation option to display a list of items( "projects" in my case), for the rows which match with the numerical value 1. Please keep my attached file open for better understanding. As per example in it,

    There are projects named project1,2,3,4,5 & 6 under input side, which I must be able to display them on a list using data validation such that the projects entered with 1 on the month column must be displayed on the output list. Hope you get it.. Help on this.

    Thanks in advance..Data Validation.xlsx

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use of conditions on Data validation LIST option

    Hi Kannanr,

    such that the projects entered with 1 on the month column must be displayed on the output list
    where you are entering 1 ?
    Also I understand that when 1 is entered you need the projects in the same row as a soruce in the validation list under the respective month in output table.. let me know if I am on right path?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    05-10-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Use of conditions on Data validation LIST option

    Hi dilipandey,

    You are on the right path.. You got a logic for that?

    Regarding this,
    Quote Originally Posted by dilipandey View Post

    where you are entering 1 ?
    1 is entered to denote the existence of a project and 0 means no existence, for a particular month . Apart from this, 1's and 0's dont got any numeric importance in my example.. Hope I made u clear now..

  4. #4
    Registered User
    Join Date
    05-10-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Use of conditions on Data validation LIST option

    Hi dilipandey,

    could you able to figure it out..??

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use of conditions on Data validation LIST option

    Hi Kannanr03,

    Yes.. I have done it using defined name powered with an array formula
    See the attached workbook. thanks.

    Data Validation.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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