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

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

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?
Mark

2. 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.``

3. ## Thanks!

Works great!
Thanks very much.

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

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

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

Giuseppegennaro,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1