Search code examples
google-sheetsgoogle-sheets-formulaarray-formulastextjoin

How to join filtered results to get this?


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:
output
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!


Solution

  • try:

    =JOIN("+", FILTER({A3:A&"("&L3:L&")"}, E3:E=F4))