working with live data
Posted by Max on January 18, 2002 10:35 AM
I would like to have excel remember the highest and lowest values of a certain cell.
I am retrieving live data, as that data changes I would like excel to remember the high and the low and contiually change as the highs and the lows change in that particular cell.
For instance. If incoming data initially gave me a reading of 100, but then went to 105 and back to 95 I would like to have 2 cells that show the High and Low of that data. One cell would contain 105 and the other would contain 95. And the live data cell would contain the current value.
The highs and lows would only change if the value of the live data cell goes higher or lower.
Thanks for your help. I know this should not be so difficult.