The formula returns a text value in a column of a table, when it encounters a blank cell it returns a 0, I would like it to return a blank. Conditional formatting in the destination cell won't work because I'll be using that data in a pivot table and it picks up the 0 even when it is not visible.

My formula is an array: =(INDEX(Analyze[#All],SMALL(IF(Analyze.Dog='3from analyze movavgtable'!$C$1,ROW(Analyze.Dog)),ROW(1:1)),10))

Thanks for your help.


Doug