How to display last item in a category

[hoser]

Back to my check register.

I have a check register spreadsheet with a running balance. My question is how could I display in a separate cell the balance that is displayed at the end of the register?

I cannot do a simple =d120 for example because everytime I add items to the register the balance goes one line down. If I add 5 items the last entry would be in cell d125. So how do I in a separate cell display the current balance that is shown in the last cell of the register?

[protonLeah]

The formula below will track the last value in column D (whether it shrinks or grows) to another cell:

Please Login or Register  to view this content.

[shg]

Ben's solution is good as long as there are no blanks. This doesn't care:

=INDEX(D:D, MATCH(1E+307, D:D, 1))

[oldchippy]

Here's a previous link you may find useful?

http://www.excelforum.com/showthread.php?t=582824

[daddylonglegs]

Simplest way to find the last numeric value in column D, in my opinion

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

[hoser]

Thanks again! Boy you guys are good.

[hoser]

OK guys, I was wondering if I could take this a step further. I used the function =LOOKUP(9.99999999999999E+307,D:D) and this works great, but now I am thinking that I would prefer a function that would not display the very last item but rather display the last item based on todays date.

Example:

11/24/07 - Mobile - gas - $30.00 - "current balance"
11/25/07 - Countrywide - Mortgage - $1000 - "current balance"
12/05/07 - Verizon - Cell phone - $50.00 - "current balance"

Let's say I know that Verizon will be automatically deducted on 12/05 so I have that in my register, but in the separate cell that I talked about above I would prefer to show my "current" balance as of todays date (in this case - 11/25/07). So is this possible?

[daddylonglegs]

Assuming the dates are all in ascending order you could try

=INDEX(D:D,MATCH(TODAY(),A:A))