Finding the last non zero value in my column

[cuatcside]

Can you take a look at my excel file and tell me how I can find the last non zero number in column D, Is there any other way to approach my goal in this simple worksheet? Thank you.
Ali

[VBA Noob]

Maybe

=LOOKUP(2,1/(D2:D41>0),D2:D41)

VBA Noob

[broro183]

hi Ali,

The below thread or its links may help:
http://excelforum.com/showthread.php?t=618673

hth
Rob

[daddylonglegs]

Couldn't the balance legitimately be zero?

[cuatcside]

Yes It can be zero and it can be a negative number too, and this list will get longer eventually.
Thank you.

[VBA Noob]

Enter this formula in D3 and drag down

=IF(OR(B3>0,C3>0),D2+B3-C3,"")

then use this formula

=LOOKUP(MAX(D:D)+1,D:D)

VBA Noob