Say you have a row or column that contains dates. Because dates are numbers,
the latest date is the MAX of the row or column.
--
Gary''s Student - gsnu200802


"Andy B" wrote:

I'm trying to base a simple '% of the total' formula on the latest range of
data at the latest date. Every time i insert a new column to update the data
i have to manually change the formula as i don't know how to write a formula
that will pick up the latest date and base the formula on that column.

can anyone help with this?

thanks
andy