Forum Discussion

Dinesh Kumar's avatar
Dinesh Kumar
Copper Contributor
Apr 23, 2018

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

 

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 23, 2018

    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)

    • Dinesh Kumar's avatar
      Dinesh Kumar
      Copper Contributor
      Apr 23, 2018
      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?
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Apr 23, 2018

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

Resources