Excel - Hide Used Items in Drop Down List

Set up the Main Table

Create the List of Items

Calculate if a name has been used

Create the list of unused names

Name the Dynamic List of Unused Names

Apply the Data Validation

Test the Drop Down List

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London