How do I return the LAST number in a column of numbers?

I have a column of numbers and I want to automatically select the last, non zero, entry in the column. How do I do that please?

Assuming your data is in A2:A6 then


(does not work with 0 values in LibreOffice 6.1 or earlier).

1 Like

Hole in one! Thank you!

Glad to help. But please do not use the Answer field for comments that are not an answer to the original question, use add a comment instead. Thanks.

And please, if the answer solves the question click :heavy_check_mark:, in the answer.