Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

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

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:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

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

How can I add here check for Current Stock?

>Solution :

Try-

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

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

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading