How to display only the last successful result IMPORTXML and ignore, if an error is returned?
The IMPORTXML formula tighten, third-party site quotes. Sometimes the result is a number that is sometimes a mistake. Is it possible formulas to make, for example, to write into a neighboring cell (and periodically update) the result of this IMPORTXML, but only if there is no error? Ie make to display the result of the last successful request.
There is only script will help. To store query results (date or number + data) into a single range script (to determine the last empty row, put the data on a timer), and from there you take the last by date error-function FILTER().