Clever lists in Excel

Another Excel solution in search of a problem. I must be able to try this out on something…

Create dependent drop down lists in Excel
“Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, and only Fruit items appear in the drop down list in column B.”​

Author: Terry Madeley

I enjoy reading about art and design, culture, data, education, technology and the web.