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
Click Here for Free Excel Templates
Enrol in Simple Sheet's Excel University - FREE Taster Course
All purchases help to support this blog - thanks!

Click Here to Buy Mediocre Wall Art (& Other Tat) by Chester Tugwell