TEXTJOIN IF (Removing Duplicates)

[Pokermonster]

Hello there,

I'm trying to do a textjoin, based on a criteria and then subsequently removes duplicates. Probably best if I provide a screenshot.

Untitled.png

So for week 1, I'm looking to return Apple and Banana.

I did a quick Google was able to find formula that did it for data displayed in rows, but was struggling to adapt it for data in column format.

Sincerest thanks for any assistance you can provide.

[Glenn Kennedy]

You can use:

=TEXTJOIN(", ",TRUE,UNIQUE(FILTER($D$4:$O$4,$D$3:$O$3=D7,""),TRUE))

See sheet.

NEXT time, remember that an editable FILE is better than a non-editable PICTURE!!