Hide Already Used Items in Excel Drop-Down List | Remove Item From Data Validation List Once Used

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 Download the featured file here: https://www.bluepecantraining.com/wp-... 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/ultimat... ************************************* Mediocre wall art and other tat by Chester Tugwell https://1-chester-tugwell.pixels.com/ ------------------------