You know how to create a drop down list in Excel, by using the Data Validation feature. Sometimes you get extra fancy, and make a drop down list that depends on the selection made in another list, using dependent data validation.

Dependent data validation works well, but there’s a loophole. In the screen shot below, I [...]