R
rhay999
I'd be very grateful if someone can help with this - tearing my hai
out!
I have a charting application "pushing" data record by record (row b
row) directly into an Excel worksheet. There are no DDE statement
involved in Excel.
I need to get a snapshot of calculations at specific points in time
when a new record comes in. Unfortunately, Excel keeps o
re-calculating everything from scratch each time a new record/row come
in, overwriting previous results.
When a row is filled (say columns A-H) then calculations will be don
(in column I) based on calculation on this row and other data held i
other worksheets. However, this calculation in I (or a copy of it i
another column) must remain permanent after it has done this firs
calculation as data in the other worksheets will change thereafter.
I've now spent ages trying to get this up and running without success
I have tried using RECALL but am finding it really difficult to get th
right coding - IF it can be used with DDE updates rather than manua
updates.
Would be really grateful of a reply from someone.
Thanks again.
Richard
Recall summary from http://www.rhdatasolutions.com/morefunc/#RECALL
RECALL
Returns the former contents of the caller cell (its contents before th
last calculation).
SYNTAX :
=RECALL(Static)
- Static (boolean, optional) : if TRUE, the function is stati
(non-volatile). Default : FALSE.
If the formula of the caller uses or refers to a cell which uses
volatile function (RAND, INDIRECT, OFFSET...), this argument should no
be set to TRUE.
EXAMPLES :
=RECALL()+1 : counts the number of recalculations in Excel.
=IF(A1RECALL(),A1,RECALL()) : returns the higher number which the cel
A1 has ever contained.
=IF(MAX(A1:B10)RECALL(),MAX(A1:B10),RECALL()) : returns the highe
number which the range A1:B10 has contained.
=RECALL(TRUE)+A1 : returns a cumulative sum of all values which hav
appeared in the cell A1.
=IF(COUNTA(A1)+1,RECALL(TRUE)+1) : counts how many times the content
of A1 have changed.
=IF(COUNTA(A1:B10),RECALL(TRUE)+1,0) : counts how many times th
contents of any cell in A1:B10 has changed, or returns 0 if this rang
has been cleared.
=RECALL(TRUE)+(A2500) : counts how many times the value of A2 has bee
greater than 500
out!
I have a charting application "pushing" data record by record (row b
row) directly into an Excel worksheet. There are no DDE statement
involved in Excel.
I need to get a snapshot of calculations at specific points in time
when a new record comes in. Unfortunately, Excel keeps o
re-calculating everything from scratch each time a new record/row come
in, overwriting previous results.
When a row is filled (say columns A-H) then calculations will be don
(in column I) based on calculation on this row and other data held i
other worksheets. However, this calculation in I (or a copy of it i
another column) must remain permanent after it has done this firs
calculation as data in the other worksheets will change thereafter.
I've now spent ages trying to get this up and running without success
I have tried using RECALL but am finding it really difficult to get th
right coding - IF it can be used with DDE updates rather than manua
updates.
Would be really grateful of a reply from someone.
Thanks again.
Richard
Recall summary from http://www.rhdatasolutions.com/morefunc/#RECALL
RECALL
Returns the former contents of the caller cell (its contents before th
last calculation).
SYNTAX :
=RECALL(Static)
- Static (boolean, optional) : if TRUE, the function is stati
(non-volatile). Default : FALSE.
If the formula of the caller uses or refers to a cell which uses
volatile function (RAND, INDIRECT, OFFSET...), this argument should no
be set to TRUE.
EXAMPLES :
=RECALL()+1 : counts the number of recalculations in Excel.
=IF(A1RECALL(),A1,RECALL()) : returns the higher number which the cel
A1 has ever contained.
=IF(MAX(A1:B10)RECALL(),MAX(A1:B10),RECALL()) : returns the highe
number which the range A1:B10 has contained.
=RECALL(TRUE)+A1 : returns a cumulative sum of all values which hav
appeared in the cell A1.
=IF(COUNTA(A1)+1,RECALL(TRUE)+1) : counts how many times the content
of A1 have changed.
=IF(COUNTA(A1:B10),RECALL(TRUE)+1,0) : counts how many times th
contents of any cell in A1:B10 has changed, or returns 0 if this rang
has been cleared.
=RECALL(TRUE)+(A2500) : counts how many times the value of A2 has bee
greater than 500