Hello everyone,

I have a spreadsheet that is fed live streaming data from my broker, so the
values are constanly changing. Is there a way for excel to capture the
highest/lowest
value in a given range over a given timeframe and return that value to a
cell. Any help would be greatly appreciated. Thanks.

Ron