I wonder if there is any formula that does the same thing for all the #N/A errors in the file, ie search and replace all, without modifying their original formulas or conditioning the cells causing the error. The range where the errors are is B22:J82 so it's not just a column or a row.An Edit -> Replace would be excellent approach.
Another less used method... Highlight all data, Edit -> GoTo -> Special -> Constants -> check Errors and uncheck everything else -> OK -> enter 0 and press CTRL + ENTER
(sorry for my previous incursion)
Bookmarks