Data validation list / named array constant

W

Werner Rohrmoser

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
 
S

Stefi

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

Regards,
Stefi

„Werner Rohrmoser†ezt írta:
 
W

Werner Rohrmoser

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
 
S

Stefi

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:
 

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

Named Range that uses "relative" range - Possible? 5
create an array with unique items IN MEMORY 1
Use Text and Cell vale to reference a named range inside a formula 1
Vlookup in vlookup - taking the result as array name 2
Validation list from Named Ranges 5
Find 2 highest point to form resistance line 5
using indirect to return a named range? 1
2 dimensional date sort 1

Top