Quote:
Originally Posted by Spencer101
So would all the #REF! errors be at the end of the list or dotted throuought the data?
If at the end, you could possible wrap your formulas with =IFERROR() which would force the results to be blank cells rather than #REF!
Would that work for you?
|
Have emailed you the workbook I'm talking about if you want to take a look. Better than trying to explain it.
Yeah the #REF! errors are scattered about throughout the results sheets.
Not sure if an =IFERROR would work as it would then paste those cells as blanks when they would still need to have the active indirect formulas for when the matching survey is imported to the workbook.