Hi Roger -

Basically trying to create a text string consisting of the selected options
from row 1, col C onwards, as selected in the subsequent rows of col C
onwards. Hope this "table" below shows it:

Selected Options Op 1 Op 2 Op 3 Op 4
Product 1 Op 1, Op 2, Op 3, Op 4 y y y y
Product 2 Op 1, y
Product 3 Op 2, Op 4 y y

Cheers

Denzil


"Roger Govier" wrote:

Hi Denzil

Can you explain a little more about what you do with the result in column B?
Dependent upon what you are trying to achieve there may be other methods
that this concatenation which you have found does not work.

Regards

Roger Govier


Denzil B wrote:
Each row from 2 on contains a product item in colum A. The top row, colums C
on, contain product options, 30. Below that, each row has place to select
the product option (y/n). Column B must get all the options selected as a
concatenated text string. concatenate(if(c2="y",c$1,""),",
",if(d2="y",d$1,""),", "...... doesnt work because 30 text entries are
needed, it is clumsy, takes forever to write up and is a mission to
modify/edit. Is there a better way?