We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

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

asked 2020-01-01 17:52:33 +0200

bwallum gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
3

answered 2020-01-03 18:14:13 +0200

erAck gravatar image

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

edit flag offensive delete link more
0

answered 2020-01-04 23:52:06 +0200

bwallum gravatar image

Hole in one! Thank you!

edit flag offensive delete link more

Comments

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.

erAck gravatar imageerAck ( 2020-01-05 14:05:19 +0200 )edit

And please, if the answer solves the question click ✔, in the answer.

m.a.riosv gravatar imagem.a.riosv ( 2020-01-05 22:44:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-01 17:52:33 +0200

Seen: 91 times

Last updated: Jan 04 '20