Excel 365 Drop Down List Demo - Hide Used Items
Quick demo of Excel drop down list, where items are hidden, after they're used.
This technique uses Excel data validation, and Excel 365 FILTER function.
See detailed steps and get sample workbook on my Contextures site:
https://www.contextures.com/xlDataVal...
Or use this short link: myctx.link/used
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: https://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips #ExcelQuickTips