Forum Discussion
Spencer2430
Nov 06, 2023Copper Contributor
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 ...
- Nov 06, 2023
=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
Nov 06, 2023Gold Contributor
=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.
- Spencer2430Nov 07, 2023Copper Contributor
OliverScheurich Brilliant Works perfectly, Thanks!!