comma delimited list from a table range

[MartinL]

Hi

I am trying to create a list, from a table, and put the result in to a single cell as a comma delimited array, where an adjacent cell in the table = x
This is totally flooring me at the moment

apple
pear	x
banana	x
strawberry
kiwi	x

The array in cell C6 should = pear, banana, kiwi

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[MartinL]

Hi Fluff

According to my account
its OFFICE365 Version 2002 (Build 12527.21236)

I'll add it to my account details.

 

[Fluff]

Thanks for that, how about

=TEXTJOIN(",",1,FILTER(A2:A6,B2:B6="x"))

 

[MartinL]

Thats awesome,

Thanks again @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.