In this tutorial, we will create a shrinking drop-down list using the dynamic array formula engine and the FILTER function.
This is an awesome technique. Every time an item is chosen in the list, the list reduces and previously selected items are not shown.
In this example, we have a table of workers and a table of chores.
We will create a drop-down list of workers names to assign to the chores. Each time a name is assigned the list will reduce to show only the remaining names.