Home > Mobile >  How do I Text join multiple cells in an array formula in google sheets
How do I Text join multiple cells in an array formula in google sheets

Time:02-04

I'm having trouble with the last part of a formula on Google Sheets.

In one column (B) I have cells occupied with different themes. These could be singular or have multiple themes in the cell separated by a comma. I'm matching these themes to theme headings and then taking the cells next to it in Column A (which contains names), combining them in a cell together to create a list of names associated with the theme.

I have managed to do this successfully if the cell only contains one theme, however if there are multiple themes separated by a comma then it doesn't work. I'm currently using =ArrayFormula(textjoin(", ",true,(IF($B$3:$B$8=F2,$A$3:$A$8,""))))

I have tried loads of things and feel like the answer is simple, but can't quite put my finger on it.

Here is the sheet - enter image description here

  •  Tags:  
  • Related