Return back header name

Dear Experts,
I want to create a formula that will return back header name when the column has got 1 against it.

Please see attached file.

FIN HR OPS DEL TRA
1 1
1
1
1 1

In above example, whenever the formula find 1 against the row, return with Header such as FIN / HR/ OPS

2nd option is, if there is 2 column populated with 1, select the 1st column - for example 1 is there in Delivery as well as in Transport

Appreciate your feedabck.

Thanks & Regards,

Here, try this:

Formula:

Please Login or Register  to view this content.

Hi,

Check the attached file.

Rajan