In this video, you'll learn how to create a dropdown list that removes the previously selected value so that it doesn't appear in the next dropdown list.

This is useful when planning seating arrangements or assigning roles to people for an event. This video is a must for anyone who needs to project manage these 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 and technical equipment 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 receive a small commission when a purchase is made through the links (but there is no additional cost to you). This helps support the channel and allows for more videos like this one to be made. Thank you 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

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.