Create a Dropdown List that Doesn't Repeat Selected Items

Creating drop down lists are a neat way to let you select items interactively. You define a list and then use the Data Validation feature to create this drop down list. One thing that it doesn't natively have is to not show you items that you have already selected in a previous cell. However there is a work around to this by using a series of other functions to source the list from. I got this tip from Debra Dalgleish's Contextures blog, dug into how it worked and wanted to share with you all. Check out the video! 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel #excel #msexcel #doughexcel