Cheers. Thanks for the feedback

--
Jacob


"Gotroots" wrote:

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

Thanks Jacob

"Jacob Skaria" wrote:

If you dont have blank cells in between try the below in Data validation
ListSource

=OFFSET($J$1,,,COUNTIF($J:$J,"?*"))

--
Jacob


"Gotroots" wrote:

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?