Tag Archives: Dynamic Dropdown

The power of Dynamic Arrays in #Excel 365

Posted on October 26, 2019 by MF

… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult.  It may require multiple steps, helper formula and/or helper tables though.  And the number of helper tables depends on the complexity of the requirement.  I … Continue reading →

Rate this:

Posted in Excel in Action, Excel Tips | Tagged , , , , | Leave a comment

Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365

Posted on November 14, 2018 by MF

The recent HOT topics about Excel should be the new Dynamic Arrays!   After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only).  … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Dynamic Dependent Dropdown by Data Validation

Posted on March 15, 2014 by MF

So many D. 😀 This is a continuation of the previous post: Not all teachers are eligible to all classes.  e.g. only Iris and David are eligible to deliver Class F, would it be feasible to have only Iris and … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment