I'm using this filter functions through out a column:
=FILTER({$A$3:$A, $L$3:$L}, $E$3:$E =F4)
The output is obviously 2 columns and could be 2-4 number of rows:
I want the output data in a single cell like this: 1(24,655)+2(10,000)
If that is impossible than at least this: 1-24,655 / 2-10,000
The closest I managed is just to put the data in single cell by using textjoin: =textjoin("-",1,FILTER(..))
which resulted in: 1-24,655-2-10,000 (I have no clue what further can I do)
Please Help!
try:
=JOIN("+", FILTER({A3:A&"("&L3:L&")"}, E3:E=F4))