Home |
Search |
Today's Posts |
#1
|
|||
|
|||
new cell with changes
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 |
#2
|
|||
|
|||
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/p...cle.asp?ID=518 Hope this helps. ---- Regards, John Mansfield http://www.pdbook.com "Daniel Gubser" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |