Shrinkable drop down list in Excel | Excel Tips and Tricks #shorts

In this Short, we create a shrinking drop-down list using the dynamic array formulas. We have a list of tasks to assign to people. Each time we pick someone from the list, their name is removed. This makes it easier to assign jobs without duplicating an individual. The dynamic arrays make this simple. A combination of the FILTER, and COUNTIF functions are used here. Link to more YouTube Shorts videos: Excel - Magic Tricks: Excel - Advanced Sorting: Excel - Conditional Formatting: Excel - Functions: Excel-Lookup: Excel - Dashboard and Visualization: Excel-