Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |