software

I have a spreadsheet with cells that update in real time. Is there a way
to monitor the highest and lowest values in these cells? I would need to
output the data to another cell so that every time the monitored cells
hit a new high or low, the other cell would be updated. Thanks--
jimbob
------------------------------------------------------------------------
jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
View this thread: www.excelforum.com/showthread...hreadid=519518In the cells that displays the max and min, enter formulas like

=MAX(A1:A10)
=MIN(A1:A10)

but substitute your data range for A1:A10.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;jimbobquot; gt; wrote in
message ...
gt;
gt; I have a spreadsheet with cells that update in real time. Is there a way
gt; to monitor the highest and lowest values in these cells? I would need to
gt; output the data to another cell so that every time the monitored cells
gt; hit a new high or low, the other cell would be updated. Thanks
gt;
gt;
gt; --
gt; jimbob

jimbob

I need to do this too.

There is a way, it's been written on these boards before and involves
about 5 or 6 cells and circular references. Quite complicated if I
remember rightly. Do you think I can find it ???

Hopefully someone will know.

Just to re-state the problem;

Recording the highest and lowest value that has ever appeared in a
single cell.

TIA.--
OptionTrader
------------------------------------------------------------------------
OptionTrader's Profile: www.excelforum.com/member.php...oamp;userid=14954
View this thread: www.excelforum.com/showthread...hreadid=519518Read this entire thread:

tinyurl.com/l5qos

Make sure you also follow the link near the bottom of the thread where Gord
Dibben is mentioned. His suggestion is your BEST option.

Biff

quot;OptionTraderquot; gt;
wrote in message
news:OptionTrader.24alvm_1141723501.2875@excelforu m-nospam.com...
gt;
gt; jimbob
gt;
gt; I need to do this too.
gt;
gt; There is a way, it's been written on these boards before and involves
gt; about 5 or 6 cells and circular references. Quite complicated if I
gt; remember rightly. Do you think I can find it ???
gt;
gt; Hopefully someone will know.
gt;
gt; Just to re-state the problem;
gt;
gt; Recording the highest and lowest value that has ever appeared in a
gt; single cell.
gt;
gt; TIA.
gt;
gt;
gt; --
gt; OptionTrader
gt; ------------------------------------------------------------------------
gt; OptionTrader's Profile:
gt; www.excelforum.com/member.php...oamp;userid=14954
gt; View this thread: www.excelforum.com/showthread...hreadid=519518
gt;

Biff

I'm not too bothered about losing data, as it's only looking at daily
High - Lows values that are irrelevant the following day anyway.

It works very well, many thanks.

p.s. Not Biffer UK option trader are you per chance ?--
OptionTrader
------------------------------------------------------------------------
OptionTrader's Profile: www.excelforum.com/member.php...oamp;userid=14954
View this thread: www.excelforum.com/showthread...hreadid=519518gt;Not Biffer UK option trader are you per chance ?

No, not me. I'm on the other side of the pond.

Thanks for the feedback!

Biff

quot;OptionTraderquot; gt;
wrote in message
news:OptionTrader.24cgjm_1141809900.9772@excelforu m-nospam.com...
gt;
gt; Biff
gt;
gt; I'm not too bothered about losing data, as it's only looking at daily
gt; High - Lows values that are irrelevant the following day anyway.
gt;
gt; It works very well, many thanks.
gt;
gt; p.s. Not Biffer UK option trader are you per chance ?
gt;
gt;
gt; --
gt; OptionTrader
gt; ------------------------------------------------------------------------
gt; OptionTrader's Profile:
gt; www.excelforum.com/member.php...oamp;userid=14954
gt; View this thread: www.excelforum.com/showthread...hreadid=519518
gt;

I tried both methods and neither does what I want. It just updates the
cell with whatever value is in the cell I want monitored. I would
think this is an easy task.......put highest vaue for B10 in D10 and
put the lowest value for B10 in D12.--
jimbob
------------------------------------------------------------------------
jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
View this thread: www.excelforum.com/showthread...hreadid=519518