Google Sheets - How to join cells into one that meet a condition

userQ4r2 0
Viewed 17

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):

enter image description here

Currently I am using formula:

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

How can I add here check for Current Stock?

google-sheets-formula google-sheets
2 Answers

Try-

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

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

Harun24hr0

Try

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

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

Bye

Terio0
Related