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())