CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
rnm-kmdi
rnm-kmdi

Reputation: 35

Arrayformula not working properly with Textjoin

Here is the screenshot of the expected output and output

I had to drag to bottom right thing down for the formula to carry over below (to produce expected output), but that doesn't have to happen with arrayformula right?

I tried removing arrayformula and only using textjoin, but all the names were in that cell...

=ARRAYFORMULA(TEXTJOIN(", ", TRUE, IF($D$2:$D$21=F2, $E$2:$E$21, "")))

thank you all in advance!

Upvotes: 0

Views: 150

Answers (1)

Dang D. Khanh
Dang D. Khanh

Reputation: 1471

If I understand what you mean, you always have to fill down formula to get result because join or textjoin does not return an array, your formula might be shorter like this:

= JOIN(",",FILTER($E$2:$E$21,$D$2:$D$21=F2))

Upvotes: 2

Related Questions