Find the highest (& lowest) ever value in a cell containing streaming data.

**MarkyQ** · 02-23-2008, 09:36 PM

Hi,
I'm using a spreadsheet which is streaming numeric data.
I need a formula which will record the maximum value ever recorded in a certain cellso that, for example, i could leave the data streaming over night, then check it in the morning to see what the maximum value reached in that cell during the night.
Then i need a seperate formula to record the minimum value.
Can anyone help?
Thanks in advance,
Mark

**mikerickson** · 02-24-2008, 12:45 AM

I think these UDF's will do what you want.

If you are watching cell A1, put =runningMax(A1) in a cell, it will return the maximum entry thereafter. If you want to reset the function, send it 0.

For example,
if you enter 0, then 3, then 4, 2, 5, 1, 0, 3, 2 in A1,

=runningMax(A1) returns 0, 3, 4, 4, 5, 5, 0, 3, 3

=runningMin(A1) returns 9.9E+99, 3, 3, 2, 2, 1, 9.9E+99, 3, 2

I hope this helps.

Please Login or Register  to view this content.

**MarkyQ** · 02-24-2008, 07:57 AM

Works great!
Thanks very much.

**giuseppegennaro** · 01-07-2014, 12:27 AM

this works great but i am having an issue if i want to monitor the high and low of 2 or more values.
i.e. if i had values in A1, A2, A3 and so on it will revert to the highest and lowest values of all 3 cells.
is there a fix to the VBA to monitor multiple unique values?

i think its because it always reverts to the stored min and stored max...

cheers

**arlu1201** · 01-07-2014, 03:38 AM

Giuseppegennaro,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.