Forum Discussion
To create a new formula in excel
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
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.
