Forum Discussion

ahmad ali's avatar
ahmad ali
Brass Contributor
Aug 02, 2020
Solved

Multiple Drop Down Lists

SOLVED Hello, could you please help me in this:   depending to the data in the Table 1 , create dynamic drop down list to be ability filling the Table 2 according to administrative division to thr...
excel
ahmad ali's avatar
ahmad ali
Brass Contributor
Aug 02, 2020

Thanks TheAntony  so much

Yes,exactly like that

 

please,I have questions:

1- the tables you inserted have filters signs ( though columns are not filtered) - are they necessary?

2- The way you got column P is that you copied column B (B6:B32) then you applied (remove duplicates) then you inserted column O accordingly(cell by cell) - ?right

 

thanks!

 

 

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Aug 02, 2020

    ahmad ali ,

     

    1. I made the helper tables into official Excel Tables (Insert->Table) so that they will expand dynamically and the formulas that reference it will also expand accordingly. They are necessary if your list may grow in the future. 
    2. Correct. I copied over unique values so I can lookup for the dynamic drop-downs in the Data Validation Formula. I did this because you had mentioned you were using Excel 2016 so you wouldn't have the latest Excel functions like Filter and Unique.
    • ahmad ali's avatar
      ahmad ali
      Brass Contributor
      Aug 02, 2020

      TheAntony 

      Thank you so much

      I can't thank you enough 

       

Resources