Google Sheets: How to get the last non-zero and non-empty value in a column?

Question

Say Column A has the following values in 7 rows:

2
[blank]
0
-0.3
0
[blank]
0

How can I get the last value in the range (7 rows) which is not empty/blank, and not zero? Therefore in this case, the correct answer would be -0.3.

Answer 1

=INDEX(A:A, MAX(FILTER(ROW(A:A),NOT(ISBLANK(A:A)),A:A>0)), 0)

Ripped off of this answer:
https://productforums.google.com/forum/#!topic/docs/kgDmjZ-zhMY