How do I make a Data Validation drop-down exclude blanks?
- by Iszi
Related: How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?
For now, I've worked around the above problem by re-arranging my sheet so all the Data Validation Source cells are in one range. I'm leaving the above question open though, because I think it still poses an interesting…