Multiple IF, ARRAYFORMULA, TEXTJOIN Returning FALSE-CodePudding

Home > Enterprise > Multiple IF, ARRAYFORMULA, TEXTJOIN Returning FALSE

Multiple IF, ARRAYFORMULA, TEXTJOIN Returning FALSE

Time：08-20

I'm trying to show sizes available for unique products in one cell. I currently have the following, however, it is returning FALSE in the cells that should be blank.

Returned value: XS,FALSE,FALSE,L,FALSE,FALSE,3XL,FALSE Expected value: XS,L,3XL

=ARRAYFORMULA(TEXTJOIN(",",TRUE,IF($B$2:$B$15>0,IF($A$2:$A$15=A2,$C$2:$C$15,""))))

Page link：https//www.codepudding.com/Enterprise/516499.html

Prev:How to call a QTextEdit widget from MainWindow and use it from another class with QTabWidget impleme

Next:There is 4unique color in column G3:G. I need a formula to count the unique value of G3:G and show i

Tags：

arrays

if-statement

google-sheets

textjoin

Links：
CodePudding