When you select items from the data validation list (drop-down list), they are no longer available for selection in subsequent cells.

Download the Excel file and step-by-step instructions here: https://www.myonlinetraininghub.com/reducing-data-validation-list

Thanks to MF Wong for the original solution which I modified in this video. You can see his example here: https://wmfexcel.com/2018/11/14/dynamic-shrinking-dropdown-with-dynamic-arrays-in-excel-365/

Check out my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

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