How to create Multiple Dependent Dynamic Drop-Down List in Excel ?

 How to create Multiple Dependent Dynamic Drop-Down List in Excel ?

DYNAMIC DROP-DOWN LISTS IN EXCEL A drop-down list is an excellent way to give the user an option to select from a pre-defined list.

Worksheet used in the video:

https://drive.google.com/file/d/1lrXvpWaaqtKwtjKo4mSJTPYsB3vow1TH/view?usp=sharing

A drop-down list that is dynamic, can expand or contract depending on changes to the source data.

Learn how to create a drop-down list in a cell using the new UNIQUE function to make the list dynamic.

UNIQUE FUNCTION UNIQUE is a Dynamic Array Formula that returns all the unique values from a data range. In other words, it removes duplicates from a data set.

Learn how to create a drop-down list in a cell using the new FILTER function to make the DEPENDENT Drop-down list dynamic.

FILTER FUNCTION The Excel FILTER function returns a range filtered on criteria you define. It can also handle multiple AND/OR criteria.

Note- In the SOURCE FIELD(of Data Validation), Instead of identifying a range of cells (such as $A$1:$A$5), it's better to reference the spill range ($A$1#). Why? Because then, Mobile Brands or Models are added or deleted from the source table, our data validation will automatically update as well.