ExcelBanter - Data validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data validation (https://www.excelbanter.com/excel-worksheet-functions/136484-re-data-validation.html)

See: Under Data Validation look at DV0014

http://www.contextures.com/excelfiles.html

"Kathrine" wrote:

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.....

Thank you! I will make an attempt tomorrow morning...
Kathrine

"Toppers" wrote:

See: Under Data Validation look at DV0014

http://www.contextures.com/excelfiles.html

"Kathrine" wrote:

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.....