+ Reply to Thread
Results 1 to 3 of 3

Required Dependent Data Validation drop down

Hybrid View

haridevadiga Required Dependent Data... 09-29-2015, 12:43 AM
FDibbins Re: Required Dependent Data... 09-29-2015, 01:01 AM
haridevadiga Re: Required Dependent Data... 09-29-2015, 05:04 AM
  1. 09-29-2015, 12:43 AM #1
    haridevadiga is offline
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Required Dependent Data Validation drop down

    Hi Friends,

    I trying to put a dependent data validation in below attached excel sheet. I have two sheet Dashboard and Data. In Sheet Data i have month wise candidate details and in sheet Dashboard i am trying to put dependent data validation.

    Now what i want is, if i select any associate from the drop down menu that time in month drop down it should show the related months of an individual

    For Eg: If i select Satish Devadiga in "Associate" Drop down menu, that time in dependent drop down "Month" it should show the months he worked for.

    Hope you got my point

    Regards,
    HD
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-29-2015, 01:01 AM #2
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Required Dependent Data Validation drop down

    Try this ARRAY formula in B4, copied down...
    =IFERROR(INDEX(Data!$A$3:$A$348,SMALL(IF(Associate=Dashboard!$B$3,ROW(Data!$A$3:$A$348)-1),ROWS($A$1:A1))),"")
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 09-29-2015, 05:04 AM #3
    haridevadiga is offline
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Required Dependent Data Validation drop down

    Hi FDibbins,

    Can i use above formula in Data Validation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 - Drop-down Dependent List
    By l3il3i in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2014, 03:46 AM
  2. [SOLVED] Creating data validation drop down lists which are dependent on other cells
    By ferrets in forum Excel General
    Replies: 2
    Last Post: 09-07-2013, 03:55 AM
  3. [SOLVED] Dependent Drop Down Lists, Data Validation, Reset Dependents
    By daxlyon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 11:15 AM
  4. [SOLVED] Multiple Dependent Data Validation drop down boxes
    By dawondr in forum Excel General
    Replies: 4
    Last Post: 01-23-2013, 10:00 AM
  5. [SOLVED] Data Validation using multiple dependent drop down lists
    By ceruppel in forum Excel General
    Replies: 4
    Last Post: 12-17-2012, 06:39 PM
  6. Dependent Data Validation/Drop Down
    By mpn1925 in forum Excel General
    Replies: 1
    Last Post: 08-10-2011, 01:19 PM
  7. Excel 2007 : Data validation drop-down list dependent on another cell
    By lister000 in forum Excel General
    Replies: 2
    Last Post: 05-12-2011, 09:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1