Thread: Data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathrine Kathrine is offline
external usenet poster
 
Posts: 48
Default 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.....