Finding last cell
=INDIRECT("B"&SUMPRODUCT(MAX((ROW(B1:B1000))*(B1:B 1000<""))))
--
Gary''s Student
gsnu200706
"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%
|