Learn Excel Episode 720: Dynamic Validation

Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.Instead, Episode 720 will show you how to set up a dynamic named list using the OFFSET function.