Without testing, you can get the one day change with

=INDIRECT("A"&MATCH(9.99999999999999E+307,A:A))-INDIRECT("A"&MATCH(9.99999999999999E+307,A:A)-1)

Adjust the final "-1" to get the other values


"ghostrider" wrote:

> Thanks alot Duke and Dom, everythings working great. The last thing i am now
> trying to figure out is how to setup a function to keep running 1 day 5 day
> and 20 day changes off the last entry (i.e. if i enter new days data on cell
> a65 id like it to automatically take that newest entry and subtract a64, a60,
> and a45). Any hints??
>
> Again thanks so much for the help.
>
> "ghostrider" wrote:
>
> > Hey all. Here is my dilemma. On sheet 1 column B i currently have 64
> > numerical entries to which i am adding 1 entry each day. On sheet 2 i am
> > trying to do the following things. First i want one cell to automatically
> > display the last entry i have made. Secondly, i am trying to do min max and
> > averages for the last 60 entries.
> >
> > I know that you need to use some combination of the count function within
> > the offset function but cant seem to get it right. I am uncertain of what i
> > should be using for the reference, rows, columns, height width parts. Any
> > suggestions???
> >
> > Thanks much.