Forum Discussion
Solved
Dynamic named range + data validation not working as expected
Hello, I have a use case where I need to set up a dynamic named range comprised of an entire column. This is the formula I am using to define the range (found on YouTube): =OFFSET('Document ...
That is because B4 on Sheet1 is empty. The source range of a data validation drop-down list should be a contiguous range without blanks.
In the attached version I have created a workaround using the FILTER function.
That is because B4 on Sheet1 is empty. The source range of a data validation drop-down list should be a contiguous range without blanks.
In the attached version I have created a workaround using the FILTER function.
This fixed the issue, thanks Hans! And appreciate the advice regarding data validation needing a contiguous range.