Forum Discussion
Name Manager using for create name which is contain atleast two name.
Hello.
I creating somthing in excel with tables. These tables has thier own name, and can be dynamic or not. Any way. I using list in cell to select each data from a tables column. For that I created names with the content of a column. Unfortunatly i had to make a kind of name which is contain atleast 2 columns. These can grow dynamicly. So I think a plus helper tabel is not the right sollution for that. I think about 3 kind of solution.
1.
=UNIQUE( VSTACK( INDEX(Tabla1[#Data];0;MATCH("Type_name";Tabla1[#Headers];0)); INDEX(Tabla2[#Data];0;MATCH("Column_name";Tabla2[#Headers];0)) )
output #name?
2.
=UNIQUE(VSTACK(Lista_A; Lista_B)) lista_A as a name
output #name?
3.
created a helper table with the existing names. Created another name and use the table in it.
output was the elements contained by the helper tabel, and the lista_A and lista_B tables each dedicated column.
So How can i create list for a cell or cells from two column which are dynamicly growing, without a user needs to touch the core modell?
Best
Balázs