+ Reply to Thread
Results 1 to 4 of 4

Dependant Dropdown List in column format

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    384

    Lightbulb Dependant Dropdown List in column format

    Hi
    I have attached a file named Dependant List for excel forum.xlsx
    In which I have added multiple as well as duplicate records in table
    I want depended drop down list for unique values of category as well as for specifications
    blank cells must be skipped
    your help will improvise my database structure & I'll be grateful
    Thanks in advance

    column C is blank column which is not in data table


    A------------------------B ---------------------------C--------------D-----------------------------------------E
    Category--------------Specifications
    Fans------------------Wall Fans-----------------------------------Category---------------------------------Specifications
    Fans------------------Exhaust Fan---------------------------------Software
    Software--------------MS Office 2013
    Software--------------Installation & Setup Charges---------------- must show unique value only -------------must show dependant value
    Software--------------Antivirus Kaspersky
    Software--------------Application Software
    Software--------------UPS Software Installation
    CAT 6 D Link-----------CAT 6 D Link
    CAT 6 D Link-----------Face Plate
    CAT 6 D Link-----------
    CAT 6 D Link-----------Connectors & Consumabels
    Acid Battery------------12 V 100 AH LED Branch
    Acid Battery------------12 V 100 AH LED ATM
    Acid Battery------------150 AH Led Inverter
    Fire Extinguishers-------ABC type 4 Kg
    Fire Extinguishers-------CO2 type 2 Kg
    Fire Extinguishers-------ABC type 2 Kg
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Dependant Dropdown List in column format

    Hello
    In the attached file you will see two columns (grey cells) of Array formulas - these must be entered with Ctrl+Shift+Enter, you will see curly brackets {} around the formula if entered correctly. Also derived from these are two dynamic named ranges: 'Category_Dropdown' and 'Spec_Dropown'. They are created using the OFFSET and COUNTIF functions. These are your dependent drop-down lists for cells E3:F3.

    Hope this helps.
    DBY
    Attached Files Attached Files

  3. #3
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Dependant Dropdown List in column format

    Here's my VBA option. See attached.
    David
    (*) Reputation points appreciated.

  4. #4
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    384

    Re: Dependant Dropdown List in column format

    It's brilliant
    Thank u so much.......

+ 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. Conditional dependant dropdown list
    By SoulPrisoner in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-22-2015, 10:07 AM
  2. Replies: 3
    Last Post: 09-03-2013, 03:26 PM
  3. Conditional format values in dropdown list?
    By xlepws in forum Excel General
    Replies: 5
    Last Post: 05-31-2013, 10:19 AM
  4. [SOLVED] Cell value dependant on dropdown list choice in another cell
    By Steveo251 in forum Excel General
    Replies: 5
    Last Post: 01-28-2013, 05:03 PM
  5. Dependant dropdown list based on cell value
    By rkabir in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-19-2012, 10:29 AM
  6. Replies: 1
    Last Post: 07-07-2009, 06:15 AM
  7. Replies: 1
    Last Post: 08-13-2005, 07:05 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