Condtional Statements

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Greetings!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have a data like below(A1:E17), In Column "F" , I need an output like this:-Tried with IF, but too lengthy.. could you please share some other formula to achieve this..&nbsp;Something like FILTER, INDEX MATCH etc..&nbsp;Thanks in Advance,Br,Anupam&nbsp;

harun24hr · Accepted Answer

anupambit1797&nbsp;You need TEXTJOIN() with FILTER().=TEXTJOIN(",",1,FILTER($B$1:$E$1,B2:E2="yes",""))To make it dynamic spill array use BYROW().&nbsp;=BYROW(B2:E17,LAMBDA(r,TEXTJOIN(",",1,FILTER($B$1:$E$1,r="yes",""))))&nbsp;See the attached file.&nbsp;

Forum Discussion

Condtional Statements

2 Replies