Forum Discussion

RábaiBalázs's avatar
RábaiBalázs
Occasional Reader
Dec 15, 2025

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

 

No RepliesBe the first to reply

Resources