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,""))
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,""))