Ignore Blank values not working correctly using TEXTJOIN function

[Bombdiggity]

I am using a TEXTJOIN formula to pull data from a table. I basically use the same formula across the board and just change the column coordinate. My issue is that in one instance the formula yields the calculated values perfectly, while in another instance the same formula yields the values, PLUS a series of zeroes for any cells in the table that are blank.

I would like for the zeros to not show as they are not relevant. I've tried many different alternatives including TRIM(), and ISBLANK() but still getting the same result. My table columns are all in the number format, except for any text. Below is a list of the formulas and the result. Notice the difference between rows 4 and 5 in the table below, one shows the zeroes and the other doesn't although the data comes from the same table, with the same formula and under the same number format. What am I missing? I've also attached an image of what the formulas are referencing. Thank you in advance for your help with this!

Result of Formulas

Organic Goat Cheese>Parsley, Fresh	TEXTJOIN(CHAR(62),TRUE,C$26:C$500)
4>0.25	TEXTJOIN(CHAR(62),TRUE,M$26:M$500)
oz>oz	TEXTJOIN(CHAR(62),TRUE,O$26:O$500)
3.04>0.02	TEXTJOIN(CHAR(62),TRUE,Q$26:Q$500)
12.16>1.57>0.00>0.00>0.00>0.00>0.00	TEXTJOIN(CHAR(62),TRUE,J$26:J$500)
oz>oz	TEXTJOIN(CHAR(62),TRUE,O$26:O$500)

 

[MARK858]

A zero is not a blank it is a value. See the thread in the link below (obviously you won't need to enter the formula using CSE)

Textjoin and skip cells with zero

Hi, Is it possible to textjoin and skip cells with the number zero. I understand I can skip blank cells with true/false etc but zero's are not blank. Example below: 1 2 0 3 4 1,2,3,4 Thanks Andrew

www.mrexcel.com

 

[Scott Huish]

Do you have zeros that are formatted not to show?

=TEXTJOIN(">",,FILTER(J26:J500,J26:J500>0))

 

[Bombdiggity]

This should work. Thank you!

 

[Bombdiggity]

Do you have zeros that are formatted not to show?

=TEXTJOIN(">",,FILTER(J26:J500,J26:J500>0))

Yes, that's exactly what happened. An iferror formula made them not show and I foolishly forgot that an invisible zero is actually a value.
'Valuable' lesson learned. Thank you so much for your help.

 

[Bombdiggity]

A zero is not a blank it is a value. See the thread in the link below (obviously you won't need to enter the formula using CSE)

Textjoin and skip cells with zero

Hi, Is it possible to textjoin and skip cells with the number zero. I understand I can skip blank cells with true/false etc but zero's are not blank. Example below: 1 2 0 3 4 1,2,3,4 Thanks Andrew

www.mrexcel.com

ahh I missed that. Invisible zeros are values. thank you very much for your help! that solved it