View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimbob
 
Posts: n/a
Default Highest High and Lowest Low


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: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=519518