Validation list question

G

Gotroots

Hi,

Is it possible to show only values in a validation list. The validation show
blanks at the bottom of the list due to the values being the result of a
formula.

Can the name created which is used in the source field be altered perhaps?
 
G

Gotroots

Didn't think you could just enter a formula into the source field.
Learned something new today.

Thanks Jacob
 
J

Jacob Skaria

Cheers. Thanks for the feedback

--
Jacob


Gotroots said:
Didn't think you could just enter a formula into the source field.
Learned something new today.

Thanks Jacob
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List with blanks 1
[values from validation list] 1
Blanks Data Validation List 4
validation list 6
Data Validation - List of unique values 2
If formula and Data Validation parallely 1
Data Validation to exclude blank cells 6

Top