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.
Tony_Breitenberg41 answered on April 4th 20 at 00:31
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().