Excel Concatenate - Please help, really stuck

D

Dip

Hello Experts,
Here is the problem, I am trying to concatenate Column A, B, C and D
into a new column.
Column A, B, C and D could have values C, R, U and D respectively. I
only need to restore unique combination while I am concatinating. In
other words, if the result is "CCRD", then I only want "CRD".
How do i do it?
Thanks for any help.
Regards.
Dip
 
B

Biff

Hi!

This assumes there will be no empty cells:

=A1&IF(B1<>A1,B1,"")&IF(AND(C1<>A1,C1<>B1,C1<>D1),C1,"")&IF(AND(D1<>A1,D1<>B1,D1<>C1),D1,"")

Biff
 
H

Harlan Grove

Dip said:
Column A, B, C and D could have values C, R, U and D respectively. I
only need to restore unique combination while I am concatinating. In
other words, if the result is "CCRD", then I only want "CRD".
How do i do it?
Click to expand...

E2:
=A2&IF(A2=B2,"",B2)&IF(COUNTIF(A2:B2,C2),"",C2)&IF(COUNTIF(A2:C2,D2),"",D2)
 
Top