Max-Min

[kierco]

Hi,

I presently use a data feed variable that typically goes through a variety of highs and lows throught the day.

Question is, how do I freeze the highest / lowest numbers so that I can review the days findings after the feed has been turned off?

Any ideas?

[swatsp0p]

Is this data feed populating just one cell and you want to 'trap' the high and low value for the day?

[kierco]

Yes. As simple as that but still puzzling to me

[swatsp0p]

I'm sure there is a way to do this, however it will require VBA coding that is beyond my meager programming capabilities.

Hopefully, one our programming aces will have a solution to share with you.

Stand by...

Bruce

[MrShorty]

Do you want to trap every local max/min, or just the overall max/min.

Here's a solution to trap the overall max/min that doesn't use VBA coding:

variable is input to cell a1
a2=if(a1>a2,a1,a2) finds the overall max
a3=if(a1<a3,a1,a3) finds overall min

because these formulas set up circular references, you need to go into the options dialog and check the box next to "Iteration" on the "Calculation" tab. It will only need one iteration, so I would set the max iterations to 1.

[kierco]

Mrshorty,

I have tried this approach and it doesnt make it. When the data stream ends the solution has to be converted to text or number. Up to that point MAX min() works with the same short comings. Your solution still relies on the loop and when one variable drops out the whole thing crashes.

Robk