Forum Discussion
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...
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!
- 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.
- 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.