Find the highest & lowest ever value in multiple cells containing streaming data using UDF

i currently have a spreadsheet which is streaming numerical data.
i would like to monitor the highest and lowest values relating to a specific cell.

i found this post helpful using UDF's however it only alows for one cell to be monitored not multiple individual cells. i think its because it always reverts to the same stored min and stored max of the oithers
the code is below. if anyone can help it would be most appreciated.

thanking you in advance

Please Login or Register  to view this content.

how is this specific cell changing

thanks for your help. that worked well. i also found this link witch does it without the need for a UDF just then.

does the same thing pretty much. you just have to allow circular references
http://www.cpearson.com/newsletter/c...2007_07_23.htm

Hello,

I have a problem with this code.
Starting with 0 in range A1:A12, if I enter 5 in A1 then runningMin will show 5 in D1 and so will runningMax in E1. If I enter 7 in A1, then runningMin will keep 5 in D1 and runningMax will change to 7 in E1. So far, so good.
Then I enter 3 then 9 in A2, runningMin and runningMax will show 3 and 9 in D2 and E2 respectively. So far, so good.
But then, if I enter 6 then 7 in A3, runningMin will still show 3 in D3 and runningMax show 9 in E3, wheras I need them to show 6 and 7 in D3 and E3 respecyively.
It looks like storedMin and storedMax keep the lowest and highest value they ever encountered.
I'd like to keep a separate Minimum and Maximum value for each individual cell in column A.
I herewith attach an example sheet of what I need.

Thank you for your help!
Regards,
Laurent

Thank you very much for your help!
I have a problem with the script when I connect multiple worksheets to different markets.
My workbook contains 50 worksheets named "Bet Angel (1)", "Bet Angel (2)", "Bet Angel (3)", ..., "Bet Angel (50)".
All of them have several dynamically updated cells, for which I use your script to detect runningMin and runningMax, which both refer to the same cells (range) in every worksheet (cells K9, K11, K13, ..., K65).
The problem is that your script works very well with a single worksheet, but not with multiple worksheets in the same workbook.
Is there an easy solution or would I have to assign a different function for each worksheet?
Thank you and best regards,
Laurent.