Gentlemen,
I created array formula in Excel 2007. It works fine, but after it runs out
of condition matching results it will display #NUM! error. I can hide that
error with new IFERROR function in Excel 2007, but my problem is the document
will be used in Excel 2003, and havent found the way how to hide that error.
If I do the IF(ISERROR(FORMILA),€�€�,(FORMILA)) it will mess up my formula
results.
<a href="http://www.eonstone.com/250/Attendee checklist .xls"I attached
portion of the file I am working on. </a. The error I cant hide is on
5S_Audit sheet, columns B,C and D.
I need some expert help here, or maybe the formula need to be put together
differently.
Any help and suggestions are highly appreciated.