… 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 wrote a blogpost for a job-assignment task more than 5 years ago. The requirement is simple: show the teacher with least hours of classes assigned to on top of a drop-down list… like the screen cast show below:
See!? The drop-down is changing according to the total hours assigned, as calculated on column F.
With dynamic arrays, this task is super easy.
You may download a Sample File to follow along.
Note: As of today, Dynamic Arrays is available to Excel for Office 365 Insider only