I have the following two formulas, first in cell A9, second in cell C9:
It does its job, but returned values in C9 are all together without any spacing or comma's or anything between. If I change the cell to wrap text, it will be in a list, which is better, but its a long list and this code is dragged down into the cells below. These values will also be pasted into a form when there is a change, so it will be some manual comma and space inserting when this is done. Is there a way to either edit this formula or change it to VBA so that a comma and space are between each value?
Excel Formula:
=UNIQUE(FILTER(Table2[[ZINC462]:[ZINC47]],(Table2[ZINC462]<>"N/A")+(Table2[ZINC47]<>"N/A")),FALSE)
Excel Formula:
=TEXTJOIN(CHAR(10),1,IF((Table2[ZINC462]=A9)*(Table2[ZINC47]=B9),Table2[Connections],""))
It does its job, but returned values in C9 are all together without any spacing or comma's or anything between. If I change the cell to wrap text, it will be in a list, which is better, but its a long list and this code is dragged down into the cells below. These values will also be pasted into a form when there is a change, so it will be some manual comma and space inserting when this is done. Is there a way to either edit this formula or change it to VBA so that a comma and space are between each value?