data validation allowing invalid values (list, source list have blank cells)
Hello!
I am trying to use data validation using a named range (list validation).
The source range is a large range (5000 rows) and most of those rows are blank.
But, the validation is allowing invalid values (values outside the list). If I force a value on the whole range (like a – instead of empty cells) it will work as it should and block invalid values, so I know for sure it’s related to the empty cells.
I tried to turn off ignore blank, but the issue persists.
I need the list with the empty cells because this is a list that will increase with time, so I can’t fix the list size.
Hello!I am trying to use data validation using a named range (list validation).The source range is a large range (5000 rows) and most of those rows are blank.But, the validation is allowing invalid values (values outside the list). If I force a value on the whole range (like a – instead of empty cells) it will work as it should and block invalid values, so I know for sure it’s related to the empty cells.I tried to turn off ignore blank, but the issue persists.I need the list with the empty cells because this is a list that will increase with time, so I can’t fix the list size. Read More