![]() This new dynamic array way of making dropdown lists only works in Excel 365 and Excel 2021.Create an expandable dropdown excluding blank cells. ![]() ![]() Create a multiple dependent drop down list.Only fast, straightforward and easy-to-follow solutions. The introduction of dynamic arrays in Excel 365 has changed everything! With new dynamic array functions, creating a multiple dependent drop-down list is a matter of minutes, if not seconds. The good news is that those methods were designed for pre-dynamic versions of Excel. The above linked tutorial describes four different approaches, each including a crazy number of steps, a bunch of different formulas, and a handful of limitations relating to multi-word entries, blank cells, etc. Making a multi-level cascading drop-down has always been a challenge. The tutorial shows how to create an Excel drop down list depending on another cell by using new dynamic array functions.Ĭreating a simple drop down list in Excel is easy.
0 Comments
Leave a Reply. |