Compare data in columns, remove duplicates and return unique values in a new column

[nitiona]

Dear Experts,

Request your support in generating excel formula for below query,

Basically I have excel containing 4 columns, having unique data. I need a formula that can compare data in 4 columns and return only unique values in a new colum with '+' separator, removing any duplicates. Sample screenshot is attached.

 

[SunnyAlv]

Like this ?

=TEXTJOIN("+",,LET(data,A2:D2,TRANSPOSE(UNIQUE(TRANSPOSE(data)))))

 

[SunnyAlv]

Like this ?

=TEXTJOIN("+",,LET(data,A2:D2,TRANSPOSE(UNIQUE(TRANSPOSE(data)))))

View attachment 106313

to many Transpose sorry

use this

=TEXTJOIN("+",,LET(data,A2:D2,UNIQUE(TRANSPOSE(data))))

 

[kvsrinivasamurthy]

Single formula in F2

=BYROW(A2:D5,LAMBDA(ro,TEXTJOIN("+",TRUE,UNIQUE(TRANSPOSE(ro)))))

 

[nitiona]

Single formula in F2

=BYROW(A2:D5,LAMBDA(ro,TEXTJOIN("+",TRUE,UNIQUE(TRANSPOSE(ro)))))

Hi thanks for your quick response. However formula returns with error as #NAME?. Please assist, what might be wrong.

 

[nitiona]

to many Transpose sorry

use this

=TEXTJOIN("+",,LET(data,A2:D2,UNIQUE(TRANSPOSE(data))))

Hi thanks for your quick response. However formula returns with error as #NAME?. Please assist, what might be wrong.

 

[SunnyAlv]

what ur Excel Version dude ? 365? @nitiona

 

[nitiona]

what ur Excel Version dude ? 365? @nitiona

hi Microsoft office professional plus 2019

 

[SunnyAlv]

hi Microsoft office professional plus 2019

in your BIO it says 365, but you are using 2019, so please change it to 2019 if you are using 2019, so as not to confuse thanks

 

[nitiona]

in your BIO it says 365, but you are using 2019, so please change it to 2019 if you are using 2019, so as not to confuse thanks

View attachment 106321

Noted and done. Thanks. Request you to assist in finding solution thanks.