Re: Sorting data from a drop-down list doesn't work

PacoPolo That's just the way it is. Data Validation list must be a (named) range (direct or indirect) or a dynamic array. You can't use a formula that creates a dynamic array.

If you can't (or don't want to) sort the column in the Stock table, create a sorted dynamic array outside the table (perhaps is in separate sheet) and refer to the first cell of the array followed by a #.

Let's say you enter the formula that you now have in the DV list box in cell A1 on the sheet 'DV_lists', then enter =DV_lists!$A$1# as the source for the list.