List headers where column contains X

[csepizoli]

Hi,

I need some help for a table, where I have a table with multiple rows and columns. In the last column I need a formula, which shows the name of the columns (headers), separated by comma where there is an X in the given cell.

I have pasted an image below with the desired result in Column10.

Screen Shot 2015-01-14 at 12.06.54.png

Can you please help?

Thanks,
Zoltan

[tchock]

try this formula:

=LEFT(IF(B2="x",B$1&",",)&IF(C2="x",C$1&",",)&IF(D2="x",D$1&",",)&IF(E2="x",E$1&",",)&IF(F2="x",F$1&",",)&IF(G2="x",G$1&",",)&IF(H2="x",H$1&",",)&IF(I2="x",I$1&",",),LEN(IF(B2="x",B$1&",",)&IF(C2="x",C$1&",",)&IF(D2="x",D$1&",",)&IF(E2="x",E$1&",",)&IF(F2="x",F$1&",",)&IF(G2="x",G$1&",",)&IF(H2="x",H$1&",",)&IF(I2="x",I$1&",",))-1)

[csepizoli]

Thanks, it works well. Mz list however has like 40 headers. Is there any way to make this formula dynamic?

[zbor]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
Since other thread is in CS subforum this thread will now be closed, you may continue in your other thread.