Formula to exclude duplicate values in a concatenation?

[ktharmer]

Hello,

Is there a formula that will concatenate cells of text along a row whilst not including any duplicates within said row.

I'm aware I can "Remove duplicates" using the toolbar function, however I want to avoid any such manual intervention.

See example data attached.

Concatenate without duplicates.jpg

Thanks in advance,

Katie

[Phuocam]

Try this ...

=SUBSTITUTE(TRIM(A2&" "&IF(B2<>A2,B2,"")&" "&IF(COUNTIF(A2:B2,C2)=0,C2,"")&" "&IF(COUNTIF(A2:C2,D2)=0,D2,"")), " ", " - ")

[mahju]

Is the column number is fixed, what is the total No. of column.

Can you please upload an excel sheet

Thanks

[ktharmer]

Thanks, PMPhuocam. Worked great

[Phuocam]

You're welcome!