How to display only the last successful IMPORTXML result and ignore if an error is returned?

Question

Google Sheets

Using the IMPORTXML formula, I pull up quotes from a third-party site. Sometimes the result is a number, sometimes it's an error. Is it possible to make formulas, for example, so as to write to the next cell (and periodically update) the result of this IMPORTXML, but only if there is no error? Those. make it so that the result of the last successful request is displayed.

Answer 1

This is where a script can help. Store the results of queries (date or number + data) in a separate range by the script (determine the last empty line, put data on the timer), and from there take the last one by date without errors using the FILTER () function.