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

 

[Yongle]

welcome to the forum

what is triggering the cell value to change every second ?

do you want only today's values or a historic log list maintained with today's values at the top ?

what is the cell reference and what is the name of the sheet ?

 

[danish6061]

Thanks Yongle for reply!
The cell value may be anything its update automatically.
I want only today's max. and mi. value.
Cell is A1 and the name of the sheet is Book (1)

 

[Yongle]

You did not answer this question
- what is triggering the cell value to change every second ?
(is this an internet query or something else ?)

 

[danish6061]

its numbers

 

[danish6061]

It is done through internet automatically

 

[danish6061]

sorry Yongle, values changes manually and last I have to find out the max. and min. value from my typed data

 

[Yongle]

Ok - I will test a couple of things when back at my PC and post some code in approx 2 hours

Do you want the 2 values placed in worksheet cells ?
Is it possible for the value in A1 to be NEGATIVE ?

 

[danish6061]

No, I want only one value in a cell.
and will be only positive
N thanks, Please do it fast if you can!

 

[Yongle]

Please do it fast if you can!

No - I will not accept your pressure
It will take as long as it takes