Formula to return column header

[smselvi]

Hello,

I am looking at formula to return the column header, see example attached. Can some one help?


Thanks in advance.
Regards
smsformula Query.xlsx

[Special-K]

Here's a solution for part of your problem.

in G3
=INDEX(B$1:F$1,1,MATCH(1,B3:F3,0))
and copy down the column

This results in header of the FIRST column with a 1 in it.

Multiple columns separated by a comma are a little more complicated.
Maybe someone on the forum has a quick solution to this.

[oeldere]

L3=

Please Login or Register  to view this content.

and drag across.

then you have to add the text together.