Array formula populates a "0" when there is not value to report, but I want cell blank

On the Sequoia teamsheet (4th tab along the bottom) in the CIWA/CINA column if you scroll down you will see that the patient named "ham" has a zero for a value. This is because there are no CIWA or CINA assessments to report from the first tab "Census Sheet". My goal is for the CINA/CIWA column to report only if there are CINA CIWA scored on the "Census Sheet" (tab 1), and leave the cell blank if there is nothing to report. Please help me out on this.

Originally Posted by Tony Valko

I didn't download your file.

Try something like this...

=IFERROR(1/(1/ your_formula_here ),"")

This is my formula...it already has the IFERROR and "" in it. =IFERROR(INDEX('Census Sheet'!$H$1:$H$24,SMALL(IF('Census Sheet'!$N$3:$N$24="S",ROW($M$3:$M$24),""),ROW()-3),1),"")

Originally Posted by kbryant414

It's clunky, but this will typically work:

Please Login or Register  to view this content.

In your case:

Please Login or Register  to view this content.

You, my friend, are too smart for your own good! Thank you! it was staring me in the face the whole time. I guess I was just trying to avoid the clunky effect, but it works so that is all I need. Thank you again.