Thanks, I've got everything working now, just dont know why.
I ve been given the following but not sure what the (2,1 does in #1 & #4,
nor the ROW -1 does.
More reading & playing to do

=LOOKUP(2,1/(B1:B100<""),B1:B100)
=INDIRECT("B"&SUMPRODUCT(MAX((ROW(B1:B1000))*(B1:B 1000<""))))
=INDEX(B:B,MATCH(MAX(A:A),A:A,0))
=INDEX(B:B,LOOKUP(2,1/(B1:B100<""),ROW(B1:B100))-1)



"JMB" wrote in message
...
Maybe you could modifiy Bob's formula to do that. This appears to work
okay:

=INDEX(B:B,LOOKUP(2,1/(B1:B100<""),ROW(B1:B100))-1)

"Jim" wrote:

This function will give me the value in the last cell, which is 3.20%.
I'm
trying to get the value in the last row before the last row.
(sounds kind of dumb) 86,963.25
Thanks Jim

"Bob Phillips" wrote in message
...
You don't need a macro

=LOOKUP(2,1/(B1:B100<""),B1:B100)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Jim" wrote in message
...
How would I reflect, in say in sheet2, the last amount in col B,
before
the % shown
in in col B, which will change as i add new dates?
In my old 123 days to find this cell i would record a macro like goto
col
B, end down,
down,end up. Not sure how to accomplise this in Excel 2003.

Thanks,
Jim


A B C D
1 2/7/07 86,051.28 1,784.53 2.12%
2 2/9/07 85,504.54 1,237.79 1.47%
3 2/13/07 85,910.57 1,643.82 1.95%
4 2/14/07 86,963.25 2,696.50 3.20%



YTD 3.20%