Home » Forums » Open Source Learning Center » Question and Answer

Difference between same cell's Value

Submitted by amit9416403848 on 19 July, 2012 - 13:09

Sir I have a problem, I have a worksheet in excel, Which one cell like A5 is

automatic updating within every second or may be twice or thrice in second.I

want to know the difference between this cell's value. example:-

Time:- 08:49:53 Cell A5- 919 A6 (Difference Cell) 120

08:49:54---- 925--- +6

08:49:55---935----+10

)8:49:56---899---- -36

Like this

Plz reply me as soon as possible

Thanks

‹ Macro to find string, copy column below string found to insert in column on same active worksheet Build a Summary ›
»
Nick's picture

if the change in the cell

Submitted by Nick on 19 July, 2012 - 17:04.

if the change in the cell triggers a worksheet change event, you can use VBA... if it doesn't you could calculate the second by second changes (but not intra-second)

Request a Quote  if you'd like us to implement it for you

»