Forum Discussion
Sorting data from a drop-down list doesn't work
I´m trying to use this formula =ordenar(INDIRECTO("Stock[Descripción de producto]"))
From Data Validation, drop-down list... but it doesn´t work
why?
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.
2 Replies
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.
