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

Viewed 10165

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.

1 Answers
Related