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"?
Comments
-
=join([Column2]3:[Column2]5,",")
if you want it to be based on criteria you need a join(collect())