Data Validation List able to work with Array Constants
Please make the Data Validation List feature work with array constants.
Like to be able to define a named Array Constant and use that in a Validation List. After all they are both lists and the Data Validation list works with a classic Named Array.
Requirement scenario is to share a workbook across organisations and ensure consistent data entry or option selection without VBA, as VBA is often stripped/blocked at organisational boundaries. This would be a very simple and straightforward solution improving user experience and organisational efficiency.
Would also like it to work with table columns e..g MyTable[My Column] and the new SORT(), UNIQUE() and SORTBY() functions