• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drop Down list dependencies Unique list

rupal1234

New Member
CarsTYPEMODEL
Hyundaih1I20
Hyundaih1I10
Hyundaih2I30
Hyundaih2I40
SuzukiS1WHITE
SuzukiS2black
SuzukiS3PINK


If I select Cars then it should show a unique identity like Hyundai and Suzuki.
And if i select Hyundai Then it should show Unique Type Like h1,h2 , likewise in Suzuki also s1,s2,s3
And in h1 (I20,I10), h2(I30,I40), S1(White), S2(black), S3(PINK)

The result should show on a different sheet.

Thanks in advance :)
 

Attachments

vletm

Excel Ninja
rupal1234
You should reread
 

Peter Bartholomew

Well-Known Member
This solution requires a Dynamic Array version of Excel.
The validation is based upon the use of filtered lists in which the current selections for the other columns determine the filter. For example
= UNIQUE(
FILTER(
Table1[Model],
((Car="")+(Table1[Cars]=Car)) *
((type="")+(Table1[Type]=type))

) )
provides the validation list for the model selection. The expressions such as
= (Car="")
ensure that blank fields do not influence the result of any filtering.
Note this approach does not assume any particular structure, such as a tree (hierarchy), for the data validation.

Since data validation does not recognise dynamic arrays, a Name such as 'ModelList' must be used to reference the array.
 

Attachments

Top