Hide Used Items in Excel Drop Down List Data Validation
To prevent people from selecting names twice, use this data validation trick, to hide the used items in an Excel drop down list.
Create one formula in a worksheet cell, to build a list of the unused names. Then, use that as the source for the drop down list
This formula uses the new SORT and FILTER functions from Excel 365.
To get the Excel workbook for this video, go to the Hide Used Items in Excel Drop Down page. It also has instructions for earlier versions of Excel:
https://www.contextures.com/xlDataVal...
Video Timeline
00:00 Introduction
00:19 New Functions
00:35 Drop Down All Names
01:06 List of Names
01:45 Build the Formula
03:04 Change the Drop Down
03:59 Get the Workbook
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips