Hello,
I often use the Data Validation List to present selectable values to a cell.
In this case, I only need the values from a range that are less than 9 characters long (there are also longer items in the same range).
I know how to use for instance the Offset function to add a range to a named range and use it as a Data Validation List, but am struggling to filter out the shorter values.
Any solutions?
Grtz, Bart
Bookmarks