A
Anto111
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:$X7>0),$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
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:$X7>0),$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