IFERROR array formula with 0 for results

[Coachmannyz8]

Can anyone assist me with this IFERROR formula; I can'tseem to get rid of the 0 (zero) when I copy the formula to the rest of thecolumn.

{=IFERROR(INDEX('RAWDATA'!$N:$N,SMALL(IF('ERProjects'!$B$4='RAWDATA'!,$R:$R,ROW('RAWDATA'!$R:$R)-MIN(ROW('RAWDATA'!$R:$R))+1,""),ROW()-3),"")}



Once all the data isdisplayed, I receive zeros for blanks coming from the raw data sheet. I figuredthat by adding the ) ," ") at the end, that it would blank out the cellbut its not.

Thanks, in advance.

 

[sandy666]

first: you've typo in your formula:

'ERProjects'!$B$4='RAWDATA'!,$R:$R

try name your formula: INDEX(....) eg. anyname. it will be treated like array formula so CSE is not necessary
then use:
=IFERROR(IF(anyname=0,"",anyname),"")

 

[Coachmannyz8]

thanks for the assistance Sandy,

good recommendation.

 

[sandy666]

You are welcome