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:
www.contextures.com/xlDataVal...
Or use this short link: myctx.link/used
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips #ExcelQuickTips

[@rnunez047]

Muy buen tip, el filtro es excluyente. Gracias, años de seguir tu canal.

[@contextures]

Thank you, Rafael - I appreciate your support!

[@Superdupershaun]

Hi, thank you for all the great information. I have a question about using the multiple drop-down list codes. Do I have to enable macros to use the codes features?

[@contextures]

You're welcome, Shaun, and yes, you'll need to enable macros for the multiple selection to work