Shrinking Drop-Down List using Dynamic Array Formulas

In this video, 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, SORT and COUNTIF functions are used here. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm The Ultimate Excel Course & Advanced Excel Tricks Bundle (Mega Deal) ► https://bit.ly/2YibpiM