up vote 0 down vote favorite
share [g+] share [fb]

In column A, I have dates. In column B, I have my body weight logged for the day. I add one row to each every day when I weigh myself, so this means the data is sorted by date ascending. The weights, of course, fluctuate (though it would be nice if they would go down every day for my own personal benefit).

For a couple of calculations, I want to get the latest (or last) weight entered in column B. Not the max or the min, but the last one entered in the column. I want it to work no many how many rows I enter.

I use Excel 2007, if that ends up mattering.

link|improve this question
feedback

2 Answers

up vote 3 down vote accepted

You can put in another cell (supposing there is no blank cell in the column B):

=INDEX(B:B,COUNT(B:B))

Note that you could also try (if your weight is not recognized as numbers and supposing you have titles on the first row):

=INDEX(B:B,COUNTA(B:B) + 1)
link|improve this answer
That was it! As soon as Stackexchange allows me, I'll mark as answered (apparently there's a time limit on that). – Chris Feb 8 at 15:10
The first was the one I used since I don't have titles, and the weights are marked as numbers. – Chris Feb 8 at 15:14
@Chris: glad it helped :) – JMax Feb 8 at 15:15
feedback
up vote 3 down vote

This version will work even with blanks in the column (assumes data is numeric)

=LOOKUP(9.99E+307,B:B)

link|improve this answer
Good call on the blanks. – Jesse Feb 8 at 17:21
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.