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
Bookmarks