I would like create a new sheet in my document and combine all values in Products sheet from column A (from A2) into one on the new sheet, when Current Stock (calculated) is greater than 1 (preferably only non blank cells):

Currently I am using formula:

=JOIN(";",Products!A2:A,"")

How can I add here check for Current Stock?

CodePudding user response：

Try-

=JOIN(";",FILTER(Products!A2:A,Products!H2:H>0))

H2:H>0 will filter out non blank number values cells.

CodePudding user response：

Try

=JOIN(";",FILTER(Products!A2:A,LEN(Products!H2:H)))

the condition is for lenght > 0, you can modify with what you want.

Bye