In this Excel video tutorial I demonstrate how to hide used items in a data validation drop-down list. This technique might be useful if you are assigning tasks to staff and you do not want to assign the same person twice.
Video Table of Contents
00:00 – Introduction
00:17 – Count already used names using COUNTIF
00:50 – Use FILTER to filter the list of staff based on the COUNTIF logical test
01:59 – Sort the names in alphabetical order using SORT
02:09 – Hide the #CALC! error
02:43 – Make your drop-down dynamic so that it includes newly entered names