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?