Expandable List without VBA

Do you need a list in Excel that can expand with your data? I made a video that covers how to make an expandable list that you can add to or remove from anywhere within the list, and, to better apply your list throughout your workbook, you may want a way to link it to drop-down lists.
In the video, learn to make an easy, dynamic, and customizable expanding list that can flawlessly link to data validation and handle duplicates (without VBA)!

Video:

https://youtu.be/XeDpu7GWs_M