new cell with changes

[Daniel Gubser]

Hello

I have a sheet which is connected via DDE, i.e. some cells get updated via
API.

I would like to analyse this data for high and low values.

How can I save this data in other cells (continuous) or print a chart
(dynamicly). Is there a funktion which adds new cells after a value has
changed?

To use =MAX() or =MIN() is not good as it is overwritten with new data.

Any ideas, links, etc. are welcome.

Daniel

 

[John Mansfield]

Daniel,

This article explains some of the methods used to update a chart
automatically as new data is entered into a spreadsheet. If you just want to
update a range, the formulas that are illustrated will do that too.

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=518

Hope this helps.