| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Concatenate
Thanks all.
"Bob Phillips" wrote: Won't happen if you want the array to be variable and the formula to cope with it, as CONCATENATE won't support arrays, so you need a UDF -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ExcelMonkey" wrote in message ... Can anybody tell me how to do a conditional concatenate. I have to columns of data. Column A has numbers: 1-5 (A2:A6). Column B has booleans: TRUE/FALSE (B2:B6) A B 1 TRUE 2 FALSE 3 TRUE 4 FALSE 5 TRUE in B7 I want to do an conditional concatenate using "&" character on column A using the booleans in column B. The result would like like this: &1&3&5. Note there is a "&" before the first number as well. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Concatenate? | Excel Discussion (Misc queries) | |||
| Conditional =CONCATENATE formula | Excel Worksheet Functions | |||
| concatenate & conditional formatting in one | Excel Discussion (Misc queries) | |||
| Concatenate and Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Concatenate | Excel Worksheet Functions | |||
Hybrid Mode
