CONCAT and IF

[bazzinga]

Hello,

I am trying to use CONCAT to give me all the information on a table as a sentence. So far my formula can aggregate Table A + Table B. Is there a way to do A+B A+B (i.e. 10 Dewberry@, 15 Early@,...) with the IF formula?

My current formula:

=CONCAT(IF(A3:A124>0,A3:A12,""),IF(A3:A12>0," "&B3:B12,""))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN(" ",,FILTER(A3:B12,A3:A12<>0))

 

[DanteAmor]

Hi and welcome

Try

=TEXTJOIN(", ",,BYROW(FILTER(A3:B7,A3:A7>0),LAMBDA(br,TEXTJOIN(" ",,br))))

 

[bazzinga]

Thank you! this is amazing.

 

[DanteAmor]

Hi & welcome to MrExcel.
How about

=TEXTJOIN(" ",,FILTER(A3:B12,A3:A12<>0))

I think the comma (,) was missing

(i.e. 10 Dewberry@, 15 Early@,...)

 

[Skrej]

How about this (adds a space between values)

=CONCAT(IF(A3:A124>0,A3:B12& " ",""))

If you don't want the space:

=CONCAT(IF(A3:A124>0,A3:B12,""))

 

[Fluff]

I think the comma (,) was missing

The OP did not show a comma, but it's easily added.

 

[Fluff]

Thank you! this is amazing.

Glad we could help & thanks for the feedback.