Easily exclude blanks from dropdown (Data Validation)
Add an option to Data Validation to exclude blank cells. Currently it involves a laborious workaround. This needs to work for Dynamic Named Ranges.
strongly agree. Should be no reason for the user to have to figure out how to exclude blank cells (either embedded blank cells or trailing blank cells).