Data Dropdown Validation List without Duplicates

This video is all about how to create a dropdown list that removes the value you selected previously so it won’t show up on the next set of dropdowns! This is useful if your planning seating table arrangements or assigning roles to people for an event. This is an essential video for anyone has to project manage these types of activities! Something similar if you don't have the latest M365 Excel with Dynamic Array Functions https://www.youtube.com/watch?v=UIsKXur3CeE 🔔 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.buymeacoffee.com/dough #excel #msexcel #doughexcel