Coachmannyz8
New Member
- Joined
- Feb 28, 2018
- Messages
- 9
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.
{=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.