My post is difficult to explain. Below you will see that
values are entered in to the worksheet on 10/22, 10/23 and 10/24. As the
entered values each day impact the calculation of A1..A3, the sum of A1..A3
updates based on the most rercent value entered (14.25 on 10/24). As the
result calculates each day, I'd like to be able to "save" the calculated
value by date and post it to the right of the A1..A3 TOTAL. Is there a way
to reference the value by the date it was calculated?
For example, when the value for 10/24 is entered, I don't want the
calculations for 10/22 and 10/23 to go away. Shift isn't a good explanation.
I want to be able to trend the daily values of the calculation A1..A3.
Thanks for your patience, and for giving this a second look.
> >
> > I'll illustrate below. I want to be able to "save" a calulated value based
> > on the date it was entered.
> >
> > I want to be able to post the results by date and have each result
> > maintained in the database. Thanks for your insight. I know this should
> > be possible.
> >
> >
> > 10/22 10/23 10/24 A1 formula result
> > 14.00 14.50 14.25 A2 formula result Results by date
> > A3 formula result 10/22 10/23 10/24
> >
> > ----------------
> > TOTAL: (a1..a3) 71.05 69.00 72.34 71.05**
> >
> >
> > The above TOTAL ** The above is based
> > on changes each date in the calculated
> > TOTAL

--
Sony Luvy