Excel Concatenate - Please help, really stuck
 

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

Excel Concatenate - Please help, really stuck
 

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

"Dip" wrote in message
ups.com...
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

Excel Concatenate - Please help, really stuck
 

"Dip" wrote...
....
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?

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