Finding the last value in a range of cells

C

cincode5

Hi everyone.

I was wondering what function in Excel can be used to return the last value
in a range of cells.

Specifically - Row 10 has 12 cells in it that contain monthly forecast
values for Jan - Dec. I need the value of the 13th Cell M10 to contain the
last value in the row that is >0.

I'm sure this is embarrassingly simply, and any insight would be greatly
appreciated.

Regards...
 
D

Domenic

Try...

=LOOKUP(9.99999999999999E+307,IF(A10:L10>0,A10:L10))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
C

cincode5

Thanks Domenic... This will do the trick. Needed to work a little to
understand arrays, but I believe I've got the answer.
 
Top