Need urgent help in excel please

danish6061

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

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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 ?
 
Upvote 0
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)
 
Upvote 0
You did not answer this question
- what is triggering the cell value to change every second ?
(is this an internet query or something else ?)
 
Upvote 0
sorry Yongle, values changes manually and last I have to find out the max. and min. value from my typed data
 
Upvote 0
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 ?
 
Upvote 0
No, I want only one value in a cell.
and will be only positive
N thanks, Please do it fast if you can!
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top