I have a row which contains numbers, blank cells and error values.
I need a formula which will return:
1. The last numeric value, ignoring blank cells and error values.
2. And that value has to be greater than 1.
I all my searches, I could only find formulas that return fulfill one of the two conditions. But never one that could fulfill both simultaneously.
Thanks in advance.
Bookmarks