You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Highs and Lows from dynamically updated cell
- Thread starter Igor
- Start date
Thank you for reply, Nebu.
The dynamically updated cell is constantly changing
Let's say that very first value is 100.
This number, since it is a first one will be both current high and current low.
The next update gives us 105.
This will be a current high (105>100), so cell for Highs will show 105
and cell for Lows will show 100.
Next update - 104
Highs - still 105
Lows - still 100
Next update - 99
Highs - still 105
Lows - 99
And so it goes until workbook is closed or it is stopped manually.
I hope I made it clear.
Thank you again and look forward for your comments.
The dynamically updated cell is constantly changing
Let's say that very first value is 100.
This number, since it is a first one will be both current high and current low.
The next update gives us 105.
This will be a current high (105>100), so cell for Highs will show 105
and cell for Lows will show 100.
Next update - 104
Highs - still 105
Lows - still 100
Next update - 99
Highs - still 105
Lows - 99
And so it goes until workbook is closed or it is stopped manually.
I hope I made it clear.
Thank you again and look forward for your comments.
Thanks again, Nebu.
Here is what I see.
Every time I click on any new cell random numbers (B5, B6) change and D5 changes as a result.
High is always stays the same. I clicked for a long time, but since we are very close to the max (2.75) and I did not get to see any high changing. So I can not say if it picks up high correctly or not.
But Lows are definitely wrong. It simply repeats previous D5 no matter the range.
Actually, I dont think simply clicking on random empty cells shoud produce any changes in B5 B6 but it does.
When I do F9 to change randoms it works to, but then Low and High stop working, meaning stop reflecting new Lows (I still don't know about Highs).
I'm curious if your file produces the same result or yours is working properly and I simply lost functionality while downloading?
Thank you for your help.
Here is what I see.
Every time I click on any new cell random numbers (B5, B6) change and D5 changes as a result.
High is always stays the same. I clicked for a long time, but since we are very close to the max (2.75) and I did not get to see any high changing. So I can not say if it picks up high correctly or not.
But Lows are definitely wrong. It simply repeats previous D5 no matter the range.
Actually, I dont think simply clicking on random empty cells shoud produce any changes in B5 B6 but it does.
When I do F9 to change randoms it works to, but then Low and High stop working, meaning stop reflecting new Lows (I still don't know about Highs).
I'm curious if your file produces the same result or yours is working properly and I simply lost functionality while downloading?
Thank you for your help.
Hi;
I have modified a bit , it is working fine at my end, try filling in some values in the cells f5 and f6 to see the changes. whenever the calculation gives the smallest or the highest values it changes the cell values f5 and f6 respectively. I have tested it step-by-step, coz it is difficult to see it when you run the macro, but as per the tests I have performed it is taking the correct values.
Thanks
I have modified a bit , it is working fine at my end, try filling in some values in the cells f5 and f6 to see the changes. whenever the calculation gives the smallest or the highest values it changes the cell values f5 and f6 respectively. I have tested it step-by-step, coz it is difficult to see it when you run the macro, but as per the tests I have performed it is taking the correct values.
Thanks