Forum Discussion

Copper Contributor

Mar 06, 2020

Trying to figure out formula

Before typing out my problem thanks for taking a moment to help. I am trying to figure out what formula needs to be used in order to populate and combine data from multiple cells into one. Say ...

Formulas and Functions

NCRoy

Copper Contributor

Mar 06, 2020

DGuzmanG

Assuming Your Heading Range is A1:C1

and input Range is A2:C2

write below array formula in D2 and press ctrl + shift + enter

=TEXTJOIN(" ",1,IF((A2:C2="x"),$A$1:$C$1,""))

DGuzmanG

Copper Contributor

Mar 09, 2020

NCRoy

But if you are using TEXTJOIN, it is because you are on Office 365 and with the recent dynamic arrange capabilities of Excel 365 it is not required to put Ctrl+Shift+Enter for array formulas anymore.