| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Named list issue | Excel Discussion (Misc queries) | |||
| Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Linear Mode
