Finding the last value in a range of cells
 

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...

Try...

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

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

Hope this helps!

In article ,
"cincode5" wrote:

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...

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

"Domenic" wrote:

Try...

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

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

Hope this helps!

In article ,
"cincode5" wrote:

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...