Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/01/Drop-Down-Hides-Used-Items.xlsx

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.

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



Enrol on the **Ultimate Excel VBA Course**
30+ hrs - includes certification
https://www.excelvbaisfun.com/ultimate-excel-pro/?ref=24
*************************************

Mediocre wall art and other tat by Chester Tugwell
https://1-chester-tugwell.pixels.com/
------------------------