Remove "Zero"

[Chief Ace]

I'm using this array formula below and I'm pretty much bummed out I can't get rid of the zero. I tried using "IF" and "COUNTIF" to no avail. Thank you for any help that you can assist.

=IFERROR(INDEX(Initial!C$6:C$700,SMALL(IF(Initial!$G$6:$G$700="Stock",ROW(Initial!C$6:C$700)-5),ROW(Initial!C1))),"")

 

[deciog]

If you are zeros of the result of the formula try this way

=IFERROR(INDEX(Initial!C$6:C$700,SMALL(IF(Initial!$G$6:$G$700="Stock",ROW(Initial!C$6:C$700)-5),ROW(Initial!C1))),"")&""


Decio

 

[Chief Ace]

Hi Decio,

Thank you for the quick response. I greatly appreciate it. But i'm a little bit confuse on what you have suggested but it works. If you don't mind me asking how an ampersand and the quotation mark work on this?

 

[deciog]

The result is transformed into text, so it hides the zeros, but if it is to use the cell for calculation, then, it must hide the zeros with cell formatting, when it is equal to zeroes paint of white..

I'm using Google Translator, sorry for writing error

I hope I have helped

Decio

 

[Chief Ace]

Decio,

That was great. Again thank you for helping and enlightening me on this. Never stop learning. Hope you have a wonderful and safe weekend. Cheers!!!

 

[deciog]

Chief Ace

If you liked the tip click on like

Thank you

Decio