Data validation list / named array constant
 

Hello,

is it possible to use a named array constant in the data validation
list like
={"Jan";"Feb";"Mar"}
I can't work it out.
Thanks.

Excel XP SP3
Win XP SP1

Data validation list / named array constant
 

Just type
Jan;Feb;Mar
in the Source field of Data validation list!

Regards,
Stefi

€žWerner Rohrmoser€� ezt Ã*rta:

Hello,

is it possible to use a named array constant in the data validation
list like
={"Jan";"Feb";"Mar"}
I can't work it out.
Thanks.

Excel XP SP3
Win XP SP1

Data validation list / named array constant
 

Stefi,

thanks your suugestion, but I have 3 long strings like
"Production Calendar STUS / 5.67 days a week".
It seems that the total lenghth of all of them is too long.

T name a range and to use this name is an other option, but
I like to know if it is possible to use named arrays in validation
list.

Werner

Data validation list / named array constant
 

If you place your long strings, say, in A1,A2,A3 cells, then select range
A1:A3 and name it, say, longstrings, then typing =longstrings in Data
validation/List Formulas field will give you the required result. Apply a
suitable column width for the validated cell to make the whole long string
visible in the drop down list!

Regards,
Stefi

€žWerner Rohrmoser€� ezt Ã*rta:

Stefi,

thanks your suugestion, but I have 3 long strings like
"Production Calendar STUS / 5.67 days a week".
It seems that the total lenghth of all of them is too long.

T name a range and to use this name is an other option, but
I like to know if it is possible to use named arrays in validation
list.

Werner