Hi guys,

I need to return the second to last value (providing it is greater than
zero) from a data range. I already have a formula to return the value in the
last cell, this being:

=IFERROR(LOOKUP(2,1/($D7:$X70),$D7:$X7),"-")

I may be missing an obvious way to manipulate the above formula but would
appreciate any help.

Many thanks in advance,

Kind regards,

Ant