Hi,

I am using TEXTJOIN to show all items that have the most and least quantities available, but if I have no items (zero quantity), the formula returns an error.

How can I return the text when the minimum is zero?

=TEXTJOIN(” – “,TRUE,IF(C:C=MIN(C:C),B:B,””))

Thanks.

​Hi,I am using TEXTJOIN to show all items that have the most and least quantities available, but if I have no items (zero quantity), the formula returns an error. How can I return the text when the minimum is zero? =TEXTJOIN(” – “,TRUE,IF(C:C=MIN(C:C),B:B,””))Thanks.  Read More

​