Need urgent help in excel please

danish6061

New Member
Joined
Mar 16, 2020
Messages
29
Office Version
2016
Platform
Windows
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
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
5,249
Office Version
365
Platform
Windows
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

New Member
Joined
Mar 16, 2020
Messages
29
Office Version
2016
Platform
Windows
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

Well-known Member
Joined
Mar 11, 2015
Messages
5,249
Office Version
365
Platform
Windows
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

New Member
Joined
Mar 16, 2020
Messages
29
Office Version
2016
Platform
Windows
its numbers
 

danish6061

New Member
Joined
Mar 16, 2020
Messages
29
Office Version
2016
Platform
Windows
sorry Yongle, values changes manually and last I have to find out the max. and min. value from my typed data
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
5,249
Office Version
365
Platform
Windows
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

New Member
Joined
Mar 16, 2020
Messages
29
Office Version
2016
Platform
Windows
No, I want only one value in a cell.
and will be only positive
N thanks, Please do it fast if you can!
 

Forum statistics

Threads
1,089,217
Messages
5,406,916
Members
403,111
Latest member
Donbozone

This Week's Hot Topics

Top