Actually, thanks to all involved, I played around with the functions given
me & changed the YTD & ANNUAL functions, which I was updating manually to:
=INDEX(C:C,MATCH(MAX(B:B),B:B,0))/$B$8
=C31/(INDEX(A6:A400,MATCH(MAX(A6:A400),A6:A400,0))-$A$5)*365 (where $A$5 is
12/31/06)

I already have 14 columns across (tracing mutual funds) & think I'll take
your suggestion & move the Ytd, etc to another column.
Thanks again for all the help.

Jim


"Dave Peterson" wrote in message
...
How about using two additional columns E:F and put those equivalent
formulas in
those cells.

And then you could actually look back to see how things are progressing.

Jim wrote:

This is what I'm actually working with:
A B C
2 84,926.02
3 2/7/07 95,000.00 1,784.53
4 2/9/07 85,504.54 1,237.79
5 2/13/07 85,910.57 1,643.82
6 2/14/07 86,963.25 2,696.50
7 2/16/07 87,114.37 2,847.62

YTD 3.35% ( =+C7/B2 formula in B9)
ANNUAL 26.04% (=+B9/47*365 formula in B10)

The YTD & ANNUAL "formula I change whenever I update my sheet.
Just trying to find a better way & one is to restructure my spreadsheet.

Jim (seem to have lost some brain cells the last 10 years)

"Dave Peterson" wrote in message
...
First, you may want to consider putting the YTD info in row 1--then the
other
formulas will work ok.

And if you use Windows|Freeze Panes, you could make it so that it (and
the
headers) are always visible.

But if your dates are in nice order (ascending), then you could use a
formula
like:

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

But you can't have any numbers bigger than that last date in column A.



Jim wrote:

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%

--

Dave Peterson

--

Dave Peterson