TheRogue
New Member
- Joined
- Aug 3, 2019
- Messages
- 23
THINGS |
Red |
Blue |
Yellow |
<tbody>
</tbody>
I have the above table that I am using as a Data Validation List. The Data in the Table is dynamic & does not always have the same # of items in it. For the purpose of Data Validation, I have given Table1[THINGS] the Named Range of "LIST" - So, my Data Validation filter is =LIST. It works great!
The problem is that the Data Selection Box Starts at the bottom & includes all of the blanks from Table1[THINGS].
Is there a way to tell Data Validation to ignore the Blanks? I can't limit the range, b/c they might be populated, next time.