S
sony654
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.
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.