Does anyone know a way to name a range as blank- i.e. with nothing? It seems excel doesn't allow this syntax for naming a range of cells, but I thought there might be a work around using some special characters or built-in excel formula?
@emilymolloy You don't really need to add a blank to your validation lists. Just make sure that you have the box "Ignore blanks" checked in the Data Validation window.
What you would want to select next if a user leaves a cell blank (or actively select a blank option). Following the example from the link you included. Say, you select Europe in the first cell, then leave Country blank in the second, would you then want the user to be able to select from all Cities in Europe, irrespective of the Country in the third? If so, please have a look at the attached file. It contains two options. On using modern Excel functions and another more along the lines of the article in the link you shared.