Find the last value <> 0

[Mats Samson]

Is it possible to retrieve the last value greater or less than 0 in a column
range when there are 0-values above the value I'd like to find? There are no
blanks in the range, either 0 or greater or less than zero

 

[Mike H]

Try this

=LOOKUP(2,1/(A1:A20<>0),A1:A20)

Mike

 

[Mats Samson]

Thank you Mike, that solved it!
I may add that IF the column (ledger) contains only 0 for the range
you will get an error (N/A). But putting the same formula twice in a
IF(ISERROR(....., it will find the last value <>0 if there is any,
otherwise display the 0.

Regards
Mats