How to text join all negative value references?

Using textjoin function or any other function in Excel. (without VBA code)

CodePudding user response：

So, had a quick play and this works:

Only did the first 3 but if() and iferror() or isblank() come to mind if there is only one, two etc results to avoid repeating | without names...

CodePudding user response：

You can use formula suggested by JvdV. You can also try TEXTJOIN() with FILTER() formula.

=TEXTJOIN("|",TRUE,FILTER(A2:A7,C2:C7<0))