Forum Discussion
Solved
Condtional Statements
Dear Experts, Greetings! 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 shar...
anupambit1797 You need TEXTJOIN() with FILTER().
=TEXTJOIN(",",1,FILTER($B$1:$E$1,B2:E2="yes",""))To make it dynamic spill array use BYROW().
=BYROW(B2:E17,LAMBDA(r,TEXTJOIN(",",1,FILTER($B$1:$E$1,r="yes",""))))See the attached file.
anupambit1797 You need TEXTJOIN() with FILTER().
=TEXTJOIN(",",1,FILTER($B$1:$E$1,B2:E2="yes",""))To make it dynamic spill array use BYROW().
=BYROW(B2:E17,LAMBDA(r,TEXTJOIN(",",1,FILTER($B$1:$E$1,r="yes",""))))
See the attached file.
