Forum Discussion
Using formulas entered as a named range as input range for a ComboBox results in 'error
As I understand it, you can't directly use formulas for the input range in ComboBoxes. You have to use Name Manager, assign an name and formula, and then you can enter the assigned name for an Input...
It is my understanding that data validation requires range references and not arrays.
=UNIQUE(Table1[Division]) would not return a reference to a range, but an array. If you entered that formula in a cell, say A1, then you could use a named formula such as:
UniqueList =offset(a1,0,0,counta(UNIQUE(Table1[Division])),1)
which would return a range reference and, I believe, could be used for data validation.
=UNIQUE(Table1[Division]) would not return a reference to a range, but an array. If you entered that formula in a cell, say A1, then you could use a named formula such as:
UniqueList =offset(a1,0,0,counta(UNIQUE(Table1[Division])),1)
which would return a range reference and, I believe, could be used for data validation.