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