Formula for Text

stephanie.blake67241

Can I use a formula to capture text from the cells below it. For example, if I have "IT-1900" in row 2 and "IT-1901" in row 3, can my summary row show "IT-1900, IT-1901"?

L_123

=join([Column2]3:[Column2]5,",")

 

if you want it to be based on criteria you need a join(collect())