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.
Click here to download the featured file.
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