Unique Names across multiple Columns

[Amaresh Agrahara]

Hello All

I am trying to create COLUMN D based on inputs from COLUMN A, C and D with Unique names.

When I use the formula from 1 column, it works.

However, when I extend to multiple columns, it does not get me the unique names.

Thank you in advance

 

[ETAF]

how about
=LET(x,SORT(UNIQUE(VSTACK(A2:A20,C2:C20,D2:D20))),FILTER(x,x<>""))

 

[vletm]

with table
=SORT(UNIQUE(VSTACK(Table1[COLUMN A],Table1[COLUMN C],Table1[COLUMN D])))

 

[p45cal]

and it goes on:

=SORT(UNIQUE(TOCOL(CHOOSECOLS(A2:D15,1,3,4),1)))

Table version:

=SORT(UNIQUE(TOCOL(CHOOSECOLS(Table1,1,3,4),1)))

 

[Amaresh Agrahara]

Thank you all for the quick feedback.

 

[GraH - Guido]

Since the boys are having fun, here is another one using trimrange notation:

=DROP(SORT(UNIQUE(VSTACK(DROP(A:.A,1),DROP(C:.C,1),DROP(D:.D,1)))),-1)