| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate With Criteria
hello
I have 5 columns that I need to concatenate IF there is a value and if the value isnt already in the other cells i.e: A B C D E Concatenated (should Read): Row 1: United Kingdom France Japan United Kingdom Italy United Kingdom, France , Japan, Italy Row 2: USA USA USA USA Row 3: France Singapore Italy Spain France France, Singapore, Italy, Spain, Row 4: United Kingdom France United Kingdom United Kingdom United Kingdom United Kingdom, France the following formula works to a point... =SUBSTITUTE(TRIM(CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1))," ",", ") it brings back the following for Row 4 (mentioned above) Row 4: United, Kingdom, France, United, Kingdom, United, Kingdom, United, Kingdom Where I would like it to read: United Kingdom, France Is this possible? Many thanks Tracey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
