To create a new formula in excel

Copper Contributor

EXCEL.JPG

I would like to create a formula to be entered in cell A5 to A10 so that the result will look like something in cell A2,A3,A4? Any ideas

 

3 Replies

Hi Dinesh,

 

If you are Office 365 subscriber with Excel 2016 the formula could be

=TEXTJOIN(";",TRUE,IF($C2:$L2=1,$C$1:$L$1,""))

above is array formula (Ctrl+Shift+Enter)

Hi Sergei Baklan,

I'm a 2016 excel user but I'm not sure if a office 365 subscriber.
I tried that formula but it does not workout. It shows #NAME?
What can be done?

That means TEXTJOIN is not available for your. Not sure about another solution right now.