![]() Where B3:B15 are the source data for your dependent drop down, A3:A15 are the source data for your main dropdown, and D3 is the main dropdown cell. To make sure the formula works correctly, you can select some value in the first drop-down list and observe the results returned by FILTER. But this time, reference the spill range returned by the FILTER function: =$H$3# To create the second dropdown list, configure the data validation criteria exactly as you did for the first drop down at step 2. That's it! Your Excel dependent dropdown list is ready for use. To have the new entries included in the drop-down list automatically, format your source data as an Excel table.Or you can include a few blank cells in your formulas as demonstrated in this example. #MAKING DROP DOWN MENUS IN EXCEL FOR MAC 2011 HOW TO#.
0 Comments
Leave a Reply. |