Validation list question
 

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?

Validation list question
 

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?

Validation list question
 

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?

Validation list question
 

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?