Forum Discussion
Using a named cell for dynamic list
Hi there, I have several experinces with Excel but this one bug me. With several option such as "yes/no" i create in a cell (lets say its A1) a name with "concatenate" formula. For exemple if I ch...
it acts funny if the list has concatenated cells, i tried enclosing it in the text function, it still acts funny and is unrelaiable. have you tried doing a power query on your concatenated list sheet and base your list on the result by associating it first with a named range?