Shrinking Dropdowns: Automatically Remove Selected Items (Google Sheets)

Ever wonder how to automatically remove selected items from the list of dropdown options? In this video, you'll learn two ways to accomplish this: the first one that does not require a script, and then we'll finish up by looking at a script that removes the data validation flag that occurs with the first method. You can make a copy of the Google Sheet here: https://bit.ly/49P2ag9