Excel——在一个不是错误或空白的列中找到最后一个值。

I need to find in a column of an excel spreadsheet the last non-error, non-blank value. The column can have several instaces of #N/A which are alternating with actual values. There are several solutions for finding the last non-empty cell, but the solutions do not consider errors, in particular if the last non-empty cell has got an error. I need to find in a column of an excel spreadsh