Find the last value < 0
 

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

Find the last value < 0
 

Try this

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

Mike

"Mats Samson" wrote:

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

Find the last value < 0
 

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

"Mike H" wrote:

Try this

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

Mike

"Mats Samson" wrote:

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