Excel Forumula to Display Text when an "x" is in a column

Question

Hello,I am trying to figure out a formula to help me do this. In the example below, I am trying to generate an entry for column b (in red). In column b, I want it to list all the fruit that have an x in their row.&nbsp;Does anyone know a simple way to do this?&nbsp;abcdef1CategoriesAppleBananaCherryDragon Fruit2Apple, Cherryx&nbsp;x&nbsp;3Banana, Dragon Fruit&nbsp;x&nbsp;x4Applex&nbsp;&nbsp;&nbsp;

bennadeau · Answer

Hi&nbsp;bcorz,Try this ...&nbsp;=CONCATENATE(IF(B2="x",$B$1&amp;" ",""),IF(C2="x",$C$1&amp;" ",""),IF(D2="x",$D$1&amp;" ",""),IF(E2="x",$E$1&amp;" ",""))&nbsp;Ben&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

bcorz&nbsp;
As variant

with
=TEXTJOIN(", ",1,IF($B2:$E2&lt;&gt;"",$B$1:$E$1,""))

Forum Discussion

Excel Forumula to Display Text when an "x" is in a column

2 Replies

a	b	c	d	e	f
1	Categories	Apple	Banana	Cherry	Dragon Fruit
2	Apple, Cherry	x		x
3	Banana, Dragon Fruit		x		x
4	Apple	x