How do I concatenate the contents of an array in Excel?

J

Johnnie Walker

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:E179>0,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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate in array formula? 1
Creating a list of value from an array 2
how to flip contents inside the cell of an excel? 2
i want to find a value in a refference array 1
How to concatenate an array of four stings using formulae (not UDF) 9
How to save contents of cell range in an array? 4
How do I join a range of cells? 1
Help! How do I ignore blanks cells in an array? 3

Top