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