Last Value in a Row

  • Thread starter Thread starter Aladin Akyurek
  • Start date Start date
A

Aladin Akyurek

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

or equivalently...

=INDEX(2:2,MATCH(9.99999999999999E+307,2:2))
 
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
 
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.
 
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.
.
Click to expand...
 
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.
 
Back
Top