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

=LOOKUP(2;1/(A2:A6<>0);A2:A6)

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

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.