Skip to content
Home ยป Hide Already Used Items in Excel Drop-Down List | Remove Item From Data Validation List Once Used

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

    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