Apr 23 2018 07:10 AM
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
Apr 23 2018 07:25 AM
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)
Apr 23 2018 07:50 AM
Apr 23 2018 08:13 AM
That means TEXTJOIN is not available for your. Not sure about another solution right now.