Forum Discussion
Solved
forming a pre meditated paragraph
hi, I am looking to form a series of pre built paragraph's from a table i have made, effectively I am looking to gather multiple different sentences into one cell. the top 9 statements are ...
=TEXTJOIN(" ",,FILTER($B$1:$B$9,BYROW($A$1:$A$9=B12:J12,LAMBDA(x,OR(x)))))
With Office 365 or Excel for the web you can apply this formula. The formula is in cell K12 and filled down in this example.
=TEXTJOIN(" ",,FILTER($B$1:$B$9,BYROW($A$1:$A$9=B12:J12,LAMBDA(x,OR(x)))))
With Office 365 or Excel for the web you can apply this formula. The formula is in cell K12 and filled down in this example.
OliverScheurich Brilliant Works perfectly, Thanks!!