Forum Discussion
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 ...
As a variant, in case your Excel recognises TEXTJOIN (Office365, Monthly Channel) you can combine it with FILTER (available to users in the same channel).
=TEXTJOIN(", ",,FILTER(1:1,2:2="x"))where the headers are in row 1 and the "x" in row 2. Of course, you may narrow down your ranges to, for example, D1:H1 and D2:H2.
Riny_van_Eekelen
I didn't knew that TEXTJOIN was Office365 only! And that FILTER match is great.
