Finding the last value in a range of cells

G

Guest

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!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup first value in row of cells 12
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Finding Last value in a column 2
VBA set thick borders around non empty cells in range 0
Calculating Average based on 3 filled cells from left in a row 6
last value 6
Last Row range 3
Lock Cells Dependent on Prior Months 1

Top