Last Value in a Row

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,2:2)

or equivalently...

=INDEX(2:2,MATCH(9.99999999999999E+307,2:2))

 

[Bill]

Is there a formula that will allow me to show the last
value in a row or column of values?

For example: I have a row that represents each day of the
month. I enter a number on a daily basis in the cells of
that row..
1/1 1/2 1/3 1/4
---------------
245 452 635 147

What I want to do is in a seperate cell, show the last
number entered. In the above example that would be "147".
on the following day (cell) I would want it to show the
new number.

Am I making sense? It's tough to explain in a forum post.
LOL

 

[PegL]

Try this:
=OFFSET($A$2:$Z$2,0,(COUNTA($A$2:$Z$2)-1),1,1)
Of course, $A$2:$Z$2 is the range where you'll be
entering data.

 

[Guest]

FANTASTIC!

Works perfectly! Thank you!

-----Original Message-----
Try this:
=OFFSET($A$2:$Z$2,0,(COUNTA($A$2:$Z$2)-1),1,1)
Of course, $A$2:$Z$2 is the range where you'll be
entering data.
.

 

[David McRitchie]

If course with the solution you chose if you have an empty cell you
will not get the last value. You might want to try the other solution
that was provided.