Ask Your Question

LoraineCooper's profile - activity

2017-12-07 09:46:17 +0200 received badge  Famous Question (source)
2015-12-14 14:47:26 +0200 received badge  Notable Question (source)
2015-12-13 14:03:41 +0200 received badge  Popular Question (source)
2015-12-03 14:47:29 +0200 asked a question How to record daily values of a cell

Thank you please close this thread

Edit by Lupp (Demand not accepted):

The issue was described here as a recurring (not strictly periodic) failure of a very reasonable approch to the task by the OP. The failures occurred when opening a file containing the used formula and resulted in the replacement of "historic" values by 0 (zero). This if I remember correctly.

The formula, placed in B2 and filled down as needed, was similar to =IF(A2=TODAY();$OtherSheet.$H$12;B2), where A2 contained the date for which the memory should save the last value the source cell contained on that date.

I will also edit now my answer to include a not yet mentioned aspect of the problem.