| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I concatenate the contents of an array in Excel?
I need to use the contents of an array function as the elements of a
concatenation. In it's simplest form, concatenate(a1,a2,a3) works, but concatenate(a1:a3) doesn't. My (attempted) formula was: =CONCATENATE(IF(H6:H179*E6:E1790,D6:D179,"")), entered as an array. It passes the results of the "" IF" as value1;value2;value3 etc, and only the first value comes through into the concatenation. Alternatives involving 174 separate "if"s, just aren't going to work! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Hybrid Mode
