+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    02-23-2008
    Posts
    2

    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?
    Thanks in advance,
    Mark

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    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.
    Last edited by mikerickson; 02-24-2008 at 12:48 AM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    02-23-2008
    Posts
    2

    Thanks!

    Works great!
    Thanks very much.

  4. #4
    Registered User
    Join Date
    01-06-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    3

    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. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

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

    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.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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