Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
In Data | validation | list
how can I define the list to contain both text constants and result of function (in my case OFFSET)? I tried constant1;constant2;=OFFSET(.....) in the dialog box, but it won't work... I use dependent data validation created from sorted list with two columns, but two specific fixed values are always valid no matter what the first selection is. I'd prefer not to enter them "100's" of times in the sorted list..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Refresh existing data when changed in data validation list | New Users to Excel |