N/A appering after preview

system · June 19, 2014, 7:55pm

Hi
Ever thing is working before I do a preview. The preview is just the spreadsheet tab to check the cell values.
I have narrowed the problem down to one line of code but cannot get it working in the preview mode.
I am sure all the functions I use are supported

Any help would be appreciated

=IF(CO2="",0,INDEX($CL$4:$CL$28,MATCH(1,INDEX(($CJ$4:$CJ$28=LARGE($CJ$4:$CJ$28,1))*(COUNTIF(CP$1:CP1,CL$4:$CL$28)=0),),0)))

jamie-lill@live.ca (BOB member since 2010-08-05)

system · June 20, 2014, 3:33pm

I cannot say for sure, but the Large function will generate an error if the array is empty. So I would suggest displaying the range CJ4:CJ28 at runtime and make sure there is data there.

kevlray (BOB member since 2010-06-23)