Learn how to create a dependent drop down list in Excel. Discover how you can create a dynamic drop down list in Excel with multiple selection. And we will also answer, what is a dynamic drop down list? And how do I create a dependent drop down list in multiple rows? <br /><br />These are the steps outlined in my video. <br /><br />Country Drop Down List <br />1) Select B2 <br />2) Data ~ Data Tools ~ Data Validation ~ Data Validation <br />3) List <br />4) Source as =$D$14# <br />5) ENTER twice <br /><br />State Drop Down List <br />1) Select B3 <br />2) Data ~ Data Tools ~ Data Validation ~ Data Validation <br />3) List <br />4) Source as =$E$14# <br />5) ENTER twice <br /><br />City Drop Down List <br />1) Select B4 <br />2) Data ~ Data Tools ~ Data Validation ~ Data Validation <br />3) List <br />4) Source as =$F$14# <br />5) ENTER twice <br /><br />Get Unique Country <br />1) Select cell D14 <br />2) =UNIQUE(A14:A109) <br /><br />Get Unique State <br />1) Select cell E14 <br />2) =UNIQUE(INDEX(FILTER(A14:B109,A14:A109=B2),,2)) <br /><br />Get Unique City <br />1) Select cell F14 <br />2) =UNIQUE(INDEX(FILTER(B14:C109,B14:B109=B3),,2)) <br /><br />The formula is the same as before except that we are using State in cell B3 as a condition and we are using data range from G2 to H97. <br /><br />Let's breakdown the formula. <br />=UNIQUE(INDEX(FILTER(A14:B109,A14:A109=B2),,2)) <br /><br />FILTER(A14:B109, A14:A109=B2): The FILTER function is used to filter data in a range based on a specified condition. In this case, it filters the range A14:B109 based on the condition that the corresponding cells in column D (A14:A109) are equal to the value in cell B2. <br /><br />INDEX(..., , 2): The INDEX function returns a value or array of values from a specified range. In this case, we are using the FILTER result as the first argument. The ", , 2" means we want to retrieve the values from the second column of the filtered range, which is column E (the first column is column D). <br /><br />UNIQUE(...): The UNIQUE function is used to get unique values from a range or array. It takes the result from the INDEX function (which already contains the values from column E that meet the condition in column D) and returns only the unique values from that range. <br /><br />In summary, the entire formula finds all the unique values in column E (in the range A14:B109) where the corresponding cells in column D (in the range A14:A109) are equal to the value in cell B2. <br /><br /><br />How do I create a dependent drop-down list in Excel?,How to create a dynamic drop-down list in Excel with multiple selections?,What is a dynamic drop-down list?,How do I create a dependent drop-down list in multiple rows?, <br />
