Need urgent help in excel please

[danish6061]

In a cell that is continuously changing every second, i need to monitor that cell and detect its highest & lowest values during a day, how can i achieve this, pls help

 

[danish6061]

I hope I clear you.

 

[danish6061]

Means there should be no contact in cell a1 and a18. Both cells value will always be differ from each other.

 

[Yongle]

But By this code the value of cell a1 and a18 will be the same but i will trigger different values in both cells thats why need different max. min, values for both cells.

The code does not change the values in either A1 or A18
Why are A1 and A18 the same ?

Monitor cell A1 - results are in Z1, Z2, Z3
Monitor cell A18 - results are in Z18, Z19, Z20

 

[danish6061]

Yes, Yes, Yes, Yongle it's working. You really a genius. This website is great. This is a very fantastic experience to talk to you.
Lot's of thanks by me. In future if I need help I will come here InshAllah.
Have a great day,,, This was very Fantastic experience.