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

English
, ,
#1

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?

CĂłmo obtener el contenido de la Ășltima celda de una columna
CĂłmo obtener el contenido de la Ășltima celda de una columna
In Calc Sheet 1 is a summary, I want to code it to list the last entry in a column for the different sheets 2-10. They are debit and credit records.
#2

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).

1 Like
MATCH() returns #N/A
#3

Hole in one! Thank you!

#4

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.

#5

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

#6

Impressum (Legal Info) | DatenschutzerklĂ€rung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.